Some of these are way before my time. But lots of good stuff here.

Dawn of War had the most epic war cry ever! THAT AINT MY OPINION ITS A FACT!

Here are some of mine intro suggestions for a fantasy game:

Lords of Magic

Das Schwarze Auge: Die Schicksalsklinge (Realms of Arkania: Blade of Destiny)

Das Schwarze Auge: Sternenschweif (Realms of Arkania: Star Trail)

Das Schwarze Auge: Schatten über Riva (Realms of Arkania III: Shadows over Riva)

All of this games had great unique soundtracks that didn't sound like a copy of Lord of the Rings as in todays games. I hope the soundtrack of Elemental will be as good as those.

There are much more games with great intros but thats all for now.

One of the most groundbreaking games of all time!! Thanks for reminding me of this!! Karma will be involved on your behalf!

...as I see many of you have mentioned some retro game intros, so here is a golden oldie: Fantasy Empires

http://www.youtube.com/watch?v=FPFbCB5Me8g

..yet another awesome intro - Warhammer: Mark of Chaos

"To me sons of Sigmar, for the Empire!" - Epicness!

http://www.youtube.com/watch?v=e3pOljQqvX8

Utopia - http://www.youtube.com/watch?v=-f2NiqpDLp0 (in italian but still the music is awesome)

Cannon Fodder - http://www.youtube.com/watch?v=PiYuq6Ac3a0

Im also pretty fond of - http://www.youtube.com/watch?v=uAgEPCltF2Q 

CHRONO CROSS: http://www.youtube.com/watch?v=lHQ7yEYwEnE&feature=related

I really like the command and conquer red alert intro, not the part  with hitler, but the one where you have the music, the title screen and some movies. I don't know why, but I like the combination of visual and music in this intro.

here is the link

http://www.youtube.com/watch?v=_R6xCWcf_VU

skip the first 2.25 minutes, It's the part with hitler that I really don't like.

As for the intro indicated above, I like ultima IV intro because it shows you a little story of how things could happen in the game. So I find it funny.

I don't share the same taste in game intros, apparently. Frogboy seems to love tiny characters running around the menu screen quite a bit, I prefer more cinematic intros.

http://www.youtube.com/watch?v=Lrp_vOSLkXE ( The Settlers II: Veni Vidi Vici )

This sort of stuff is more of my thing.

Here is my 2nd favorite all time PC game intro

2nd best PC game intro EVER!

How can you not read the previous posts?

I didn't forget about it, I just posted the sequel's version since I like that song better.

But always cool to see another fan of the series!

Sorry about that!  I saw the 'Alternate Reality Dungeon' title and didn't realize that it was a sequel to the original AR (I didn't click on the link because it sounded like another D&D game  )!  I never knew they came out with a sequel!  How did it compare to the original? 

The game that made me fall in love with video games

Wing Commander 2 - http://www.youtube.com/watch?v=wfAoVX_VWWs