Alright
1) Departure on a New Trip (Shenmue II)
http://www.youtube.com/watch?v=YNBatWu5WXYThe song just feels adventurous, fit for an epic tale. Its bombastic, fast tempo and fits well with a story that brings the character around the world.
2) Departure for Hope (Shenmue I)
http://youtu.be/wUO93H-4LmcOn the other side of the spectrum, this song is so calming, fitting the scene it was in, of a man reading the last letter his father wrote to him before his death.
3) The Great Warrior (Final Fantasy VII)
http://youtu.be/lrI8bHs6QvkThe music of Final Fantasy VII is great, the game is overhyped but the music is great as all hell. The slow tempo is just soothing in this, befitting a dramatic scene of reunion.
4) The Eight Melodies (Mother)
http://youtu.be/vpfPb_dDDpcThe song has alot of emotional weight in this melody, so much so it is used to defeat Giygas and send his ass packing. Its a love song pure and simple.
(I like this animation of it
http://youtu.be/XkzAi-Lp9w4)
5) Sacrifices (Actraiser)
http://youtu.be/PdAzreSAmY8A song made for the death of a man, and in the game is the first song ever. Its a mournful waltz, and it was made in the honor of a lowly man.
6) Woodman (Mega Man 2)
http://youtu.be/YFOuUUR0QX0Why is this so good? The boss it represents is a tree?
7) Wind Temple Theme (LOZ Windwaker)
http://youtu.be/ROT3tJ11LSgThe song is atmospheric, and musically tied to the dungeon with an extensive use of wind instruments, and other organic sounding instruments to accompany the wind instruments.

Bloody Tears (Castlevania)
http://youtu.be/e2oZtvjg5oACastlevania II was not so good, but this quick paced song was just great.
9) The Best is Yet to Come (Metal Gear Solid)
http://youtu.be/6miaTf1gF4gSnake is a tragic hero, Metal Gear is a tragic story. This song, in its tone works with this in mind. Obviously inspired by Celtic music, the song has a charm that does not fail to impress. I wanted to gush at the song during my MGS The Twin Snakes LP but they only play it during the credits and opening cinematic in that version.