Well let's start off by saying this song is like crack for the ears:
Ok now with that out of the way, here's the ones that have left the greatest impression on me over the years:
1. Empire Earth Title Track: certainly the most epic music I've ever heard in its genre. Pardon the apparent low bitrate of this particular recording of it:
2. Megaman X, X2, X3 soundtracks. Though for the SNES, these tunes rocked, and were done so well you could easily imagine their sound as legit rock tunes. Megaman isn't aka Rockman for nothing, after all. However, now we have this awesome guy so we can no longer leave anything to the imagination:
And while we're here with this guy, lets go to #3 as well, since he did a bunch of metal covers for Chrono Trigger as well. The game's music is hands-down the best complete work of video game music I've heard, with Frog's Theme being my favorite track:
4. last, and probably also least, I nevertheless very much like the title and hobbiton themes from the Lord of the Rings Vol 1 for SNES, even though the game itself wasn't exactly spectacular: