Best game music:
Actraiser (SNES)
Final Fantasy 3 (SNES, FF6 japan)
Viewpoint (NeoGeo)
Castlevania: Symphony of the Night (Playstation, I still remember every note of the guitar piece)
The Sims (PC, the build mode music)
Side note about The Sims build music. If you like this look into a artest named George Winston. Although I doubt he did the music for the game, it sounds very much like him in both sound and playing style.
-nut