Most catchy game intro tune

[Father2u]

It may not be in a game, but I think the ZP intro is awesome.

 

[DraftPickle]

Bioshock, somewhere beyond the sea, i had that in my head for months and now its back.

 

[Keylime Pie]

It's been said but the music from Kingdom Hearts. Also the music from the Final Fantasy's, any one it really doesn't matter to me.

I actually really like (Though it probably doesn't count but eh) Air Man ga Taosenai (Air Man Will Not Die) http://www.youtube.com/watch?v=KLbFctG3tw0 from Rockman 2