Try not to post too many because no one likes swimming through a wall of titles and links.

My favorite would probably have to be...

The Chrono Cross Intro: Scars of Time

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

What's yours?

hmmmmm idkkk lol this prolly isnt my favorite but i like it. its tales of symphonia :]

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

Final Fantasy 8 - Nobuo Uematsu
http://www.youtube.com/watch?v=3H2WietzG-A

Lost Odyssey - Nobuo Uematsu
http://www.youtube.com/watch?v=pzDywyPnTbg

DMC 4 - Not sure
http://www.youtube.com/watch?v=JTOzCCj2Xl4

The NA version is so much more epic...

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

yea haha i kno i was watching both and i couldnt figure out wich one to use so i just picked xD

The Japanese opening gets on my nerves...

too squeaky.

yeah true true they could change the voice of the singer lol

The kingdom hearts intro's were pretty good but as my favorite I don't have one!

the tales of vesperia intro both english and japanese are my first favorites
and my second is the kh2 op

Digital Devil Saga 1: http://www.youtube.com/watch?v=Vib3etzBnks I absolutely love Mary Elizabeth McGlynn's voice.

Digital Devil Saga 2: http://www.youtube.com/watch?v=PZlRP037ifU&feature=related Catchy song.

Nocturne [Title Loop 1]: http://www.youtube.com/watch?v=6RdbZeOxL2o&feature=related The text in the beginning is pretty interesting.

Nocturne [Title Loop 2]: http://www.youtube.com/watch?v=LLkdxzD_gFU I love the music in this.

Edit:

Oh wait, you're talking about the intro after the title screen, aren't you? Lol, whoops. In that case, I like the Kingdom Hearts opening since it's the only one I can think of at the moment.

The Witcher... possibly one of THE most atmospheric intros I've seen in a long time (portrays Geralt as a real badass character and defines his Witcher profession very well with their focus on potions and guile more than using just brute strength to get the job done). I recommend the game to all RPG fans out there.

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

kingdom hearts ........my fav game intro.....ummmmmm its a little remixed but its cool...its the english and japenese version mixed .....listen its kinda very good....to me





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

I loved Chrono Trigger's PSX opening and the first Kingdom Hearts' opening. x)

Donkey Kong 64 intro > all other video game intros

Total Annihilation, Half Life 2, and the Red Alert series have great opening scenes