That was a good Mortal Kombat.

The Witcher 2 title screen and music is so epic, drives home what a polished blockbuster production they made that time around. Just hearing the music my fiance turned to me like "holy trout, what the hell are you watching?"

My favorite gameplay intros are FFVII and Metal Gear Solid 4, how they start with an impressive cut scene only for you to take control basically in the middle of it, with no camera breaks. FFVII introduced the technique to gaming and Metal Gear has made some of the best use of it.

Also Uncharted 2. That segment just announces the game you're about to play will be an unforgettable experience.