Master Of Orion 2 ... TIE Fighter (or if you’re rebel scum: X-Wing, or X-Wing vs TIE Fighter) ... Warcraft II ...

X-Wing Alliance too, it's a relatively modern game, but there's something about the campaign. You really feel yourself a rebel.

They all have that atmosphere of going into the sea for real, I don't know how to describe it.

Another old game with it is Ascendancy. I always get too emotional from its style and music, somehow it reminds me of how I dreamed of future in my childhood. But I didn't play a lot of it for the same reason.

Master of Orion 2 is just very playable and comfortable.

TIE Fighter has that sense of humor similar to Dungeon Keeper in some sense.

X-Wing I like more, because of its atmosphere, again, you really feel yourself a rebel.

XvT is for a group of friends.

WarCraft II has amazing music. Other than feeling yourself in a world where moral alignment is not 2-dimensional, but 3-dimensional, chivalrous honor being the one forgotten. You might not feel yourself the good guy necessarily, but that honor you'll feel in its campaign. A bit like in Harry Potter such a character as Bellatrix Lestrange has that quality maxed out in the positive direction, which makes her an interesting character compared to most DEs who are both baddies and spineless cowards.