If anyone asked me this question years ago, I probably would have said something like Snake Eater.
But now, I can say that "The Best Is Yet To Come", when played on Shadow Moses on Metal Gear Solid 4, really hits you hard. When it first played, I sat there in the snow just listening. That whole level was both nostalgic and very, very sad.
The Black Mages version of One Winged Angel was badass on Advent Children. Actually, a lot of Final Fantasy songs are just truly amazing. The Dark Messenger (FFIX), The Man With The Machine Gun (FFVIII), and pretty much most of the Crisis Core soundtrack.
Although, never put in any video game, the best video game song covers are done by Powerglove. Search your feelings, you know this to be true.
But the greatest song
ever would have to be Stardust, from the Atari game Lazy Jones [http://upload.wikimedia.org/wikipedia/en/1/15/David_Whittaker_-_Lazy_Jones.ogg]. Sounds familiar? You've probably heard the Zombie Nation remix, Kernkraft 400 [http://upload.wikimedia.org/wikipedia/en/0/08/Zombie_Nation_-_Kernkraft_400.ogg]
-Zen- said:
Scars of Time (the theme to Chrono Cross) is hands down the finest piece of music I've heard in a game.
I will forever remember this as this
hardest Stepmania song in existence. Well, the remix.