ff8 opening movie was great. Also the goldeneye music as well as metal gear solid 2

Ah, can't choose, there are far too many totally awesome ones! But Brawl has got to be the very best ever.

Damn.. I was gonna say that. Are you psycic?

Lost Odyssey is awesome. Heres the intro it's kinda 2 parts. Opens with a battle then the proper intro kicks in. FF8's battle is good. But this is just pure genius.

AHHHH this thread is a bitch!!! Thats a tough quesiton Soriku :(

I'ma say one that hasn't been mentioned yet with Chrono Cross

God I LOVE the ochrestrated stuffs :D Yasunori Mitsuda is a genious ^^

The Wild Arms opening has been mentioned, and it's friggin fantastic :)

Final Fantasy 8's was epic and amazing ^^

Chrono Trigger of course

+1 for Secret of Mana :D

Zone of the enders 2!!! Not really an opening, but an intro :) But regardlessly, beyond the bounds is an amazing song ^^

I'll definitely give some Kudo's to Metal Gear solid 2's opening :P I LOVE that song.

I REALLY liked the opening to Wild ARMS 2

Too many!!! Theres like 8 million more memorable ones :3

FFIII/6 for me.  (Here's the complete opening):

And thank goodness thanny didn't post a link to his 'greatest'.

Too many to count :)

In no particular order:

Tokimeki Memorial ときめきメモリアル (Sat/PS1)

The Drama Series installments were produced by Hideo Kojima nonetheless. This one contains the opening but it is extended to include other scenes from the games.

===

Sentimental Graffiti センチメンタルグラフティ (Sat)

===

Wild Arms (PS1)

===

Lunar Silver Star Story (Sat/PS1)

===

Rage Racer (PS1)

===

FF VIII (PS2)

===

Nemesis 2/Gradius 2 (MSX)

GT2 Japanese Intro (PS1)

===

Sonic CD Jap Intro (Mega CD)

Psychic Force (PS1)

===

Tales of Phantasia (PS1)

===

Rising Zan Jap Intro (PS1)

Bulk Slash / バルク スラッシュ (Sat)

===

Blue Seed ブルーシード (Sat)

===

 Thunder Force IV (MegaDrive)

Hands down:

http://www.vgmusic.com/music/console/nintendo/nes/dw1intro.mid

Direct link doesn't work. Copy and paste it.