I liked most of the music in FF7 and FFX, same with the intro movies on MGS2 and 3.
But most of the time though, I just have the TV on mute since I'm listening to my iPod or something while playing a game, so it's not often that I do listen to the music on the game.