I was tempted to post another of Jeremy Soule’s works, Total Annihilation, but that’s a case where the entire soundtrack is epic; not as “memorable” in the sense of being catchy or an earworm as some of the classic console games.
Of The Elder Scrolls games, the Morrowind intro still takes the cake for me, that tune always randomly enters my head:
And in other RTS intros, Hell March 2 (all of Frank Klepacki’s music is awesome, though):
Generals, one of the other games in the C&C universe also had memorable tracks, particularly on the GLA side (that game was fairly prescient, with GLA being very ISIS-like more than a decade prior to its rise):
In more recent games, Prey (2017) was an “instant classic” for me:
And another Mick Gordon soundtrack, which obviously is paying an homage to the original DOOM.
The spiritual progenitor of Prey:
And in unreleased games, this track is in my “Your Ass Is Dragon” playlist (my workout playlist ). Not sure if it counts since it might just be a trailer track: