Overall, I'd definetly have to say Chrono Trigger, as the music always seem to fit the mood of whatever is going on perfectly.

Behind that, it's a tie between the Metroid and Castlevania games. I've been listening to a lot of ones from Symphony of the Night lately (which I've never gotten the chance to play), and it's very nice indeed.