I know they are not openings, but there are a couple of title screens that have really stuck in my mind.
Civilization IV - Would only be decent without the music. But now it's awesome!
The Original Halo title screen was also compelling mainly due to its music.
When I first saw it, Brood War's opening cinematic was the most awesome thing ever. Not so impressive today though.
This is invisible text!







