A game who's soundtrack I enjoyed more than the game? Easily Final Fantasy 8. One of Uemetsu's better works for soundtrack, but I just couldn't stand the game itself.
As far as other notables (of which I may or may not enjoy the music more than the game), I would also list the following games as having really good music:
- World of Warcraft (Yeah, it's just an MMO, but if you actually took the time to listen to the soundtrack, it's really well done)
- Castlevania (most of them have really good soundtracks, especially SotN)
- Heroes of Might and Magic III (probably the last good game of the series, simply amazing music)
- Xenosaga (and on that note...)
- Xenogears (both had amazing soundtracks that I've been meaning to get)
I could probably list some others if I wanted to. Simply put, music is one of the things that I tend to enjoy about most video games. Sometimes I can enjoy watching a friend play a game simply because I like listening to it.