Road Rash:
http://www.youtube.com/watch?v=kFkxYUxxtD4
The only thing that topped the intro were the winner/wrecked clips

Ahhh... so many hours spent on this game.

The intro to Sonic CD is probably the best I've ever seen.
[url]http://www.youtube.com/watch?v=8JcT0VgUim8&feature=related[/url]

one of the coolest intros in my mind was the one for Star Wars X Wing Alliance, very star-wars-y! Also the intros for TIE Fighter, and the original X Wing were good. While Im thinking of it too, the intros for Full Throttle and Day of the Tentacle were genius!

If its lucasarts, its gold basically
Afterlife Intro, Afterlife Tutorial (I REALLY want this game here!)
Grim Fandango Intro
Star Wars Dark Forces 2: Jedi Knight

Someone already mentioned this, so here's a link to the clip on YouTube....
Diablo II - intro
D (1 & II), Another fundamental pillar of my videogaming career....

I remember playing it for the first time and I was just in awe of the visuals and it was so amazing that I actually got killed because I didn't notice anything!