MechWarrior 2. The music playing is the background of the intro mixes perfect with radio chatter, there was jsut something about it that was just so.... 'cool'.
Oh yeah and Unreal Tournament... That game had awesome intro music, and the series in general has very appropriate music.