Hmm. I would metion:

Z.A.R.
Worms 3D
Unreal Tournament 2003
Doom 3

While I played all of these already, and even own Worms 3D and UT 2003 on discs, I would love to also own them on GOG.

I on the other quite enjoyed the world of Heroes V. It actually also has a decent amount of lore behind it. A very fleshed out setting which while it has not much to do with the original Heroes games (and we don't talk about IV), I even found myself reading about in my spare time.

And it has to be said that I enjoyed the campaigns the most in Heroes V.

Honestly, for as much as I love Heroes 2(which is almost a perfect game) and Heroes 3(which offsets its awful sprite work with superior campaign design), the best written campaign is from Heroes 4. Don't get me wrong, Heroes 4 is a broken game, with horrendous sprite work and a non-functional AI, but when it comes to writing it's the best the series has seen. Somebody that actually went to writing school worked on those campaigns, it wasn't 'Joe the intern' during his coffee break.

Well, come to think of it, the main reason I could never fully enjoy the stories of Might & Magic and Heroes games was the entirely sci-fi background story. As V got completely rid of that, I actually liked following it. The voice acting also definitely helped.

Not all this stuff about Ancients, creating planets and worlds with names like VARN-4 (Vehicular Astropod Research Nacelle) or CRON (Central Research Observational Nacelle) where the games actually take place. Kreegans are basically aliens and not demons. At the end of M&M VII, you even get access to "ancient weapons", which are pretty much blasters etc. I've found that I preferred V going full fantasy without the sci-fi backdrop.

Not much of this is visible in the games themselves, but reading about the surrounding lore was much more enjoyable to me for the world of Heroes V.

A good point to start with Heroes V lore is reading either about Asha or Ashan itself:
https://mightandmagic.fandom.com/wiki/Ashan
https://mightandmagic.fandom.com/wiki/Asha

MM6 too. And considering their power, suddenly all other weapons training becomes useless. And rather breaks the flow story/atmosphere-wise too. But it is a series staple, and some enjoy specifically that. Could take it or leave it myself.
In case of HoMM it's the gameplay I could never deal with despite banging my head against it for a long time in 2 and 3, referring to the required hero trains, units being unable to wander without a hero and heroes not being actual combat units and fleeing if their armies are wiped, as in everything that 4 finally fixed, making it the one HoMM game I liked (and a whole lot!), and which was then reverted in 5 (however, played ToEE and could finish it, not just banging my head fruitlessly against the first couple of scenarios in any campaign as in 2 and 3, not entirely sure what made the difference). And since I could never get past the early stages, didn't get to see much of HoMM lore outside of 4 either...

The caravans added in Hammers of Fate were a great middle ground choice I'd say. You can send units from towns and dwellings into other towns in autonomous caravans, not having to manually collect them every week. It also drastically increases the strategic importance of any towns you own. Not sure if you spotted the option as it's somewhat hidden on the town screens. But it mostly eliminated the need for the "hero trains" known from Heroes I-III, pretty much just reducing it to a single hero that brought you all the reinforcements. You also have the option of spending mana and a part of your movement to summon units from a town. Heroes V has a ton of options.

When I tried IV briefly, it felt like a ton of annoying micro-management, having to move tons of units every turn, one by one.

Ah, that might have been it. Can't say I remember anything from it, but sounds like the sort of thing that'd have made the series finally playable for me.

And I like micromanagement.

Don't forget that the Angels and Archangels are actually robots.

I never played it, but I used to watch my brother play it. I think it was the first in the series to feature car customization(better engine, breaks, cpu, ...). I do have some nostalgia for it, just for that. Other than Revolt, I don't remember ever playing a driving game, so I don't have the muscle memory for the genre.

And speeaking of, other than Descent, I've never played a flying game. And other than NBA Jam, I've never played a sports game. :))

That's be a theme for another thread, genres you played very few games in :)

But from those, for me flying games would just be Elite Plus (most likely) and F-15 Strike Eagle II, if both space and aircraft count. Note the age of both.
Driving, have a few, but also mostly very old. Test Drive, Stunts, Lotus: The Ultimate Challenge, Grand Prix Circuit, Grand Prix 2, Need For Speed: Porsche Unleashed and, briefly, what I believe was F1 Challenge '00-'02 (recall doing a short race with assistance and seeing that it was basically auto-win, then tried without and saw I could barely keep the car on the road). And Megarace if that counts. And not sure if Road Fighter on a NES clone counts.
Sports (other than racing), hmm... 4D Sports Tennis (or tried, basically just practice sessions against the ball machine, as I could never figure out how to serve), Arcade Volleyball (a bit, if that counts), The Games: Winter Challenge, Serve & Volley, 2 FIFA games (before 2000), Also, if these also count, 3 Championship Manager and 1 Football Manager games, Sharkey's 3D Pool, a Chessmaster game and Hattrick, and briefly I think some other pool game, maybe Virtual Pool. And Tecmo Cup: Soccer Game on that NES clone, and Track & Field on the ZX Spectrum clone.