RDR was great. Braid's was great. Most Zelda's are great. I like all of the early MegaMan game soundtracks. I think Shenmue had my favorite orchestral one. Katamari Damacy might be my favorite though.
EDIT: I forgot Arcanum! That's my all-time favorite.
Persona 3/Persona 3 FES/Persona 4/Persona 4 Golden/Persona 4 Arena
All Congregate in a HUGE EarGasim
Hah, I knew I couldn't be the only one! I've also been listening to these tracks for the past year. They just never get old.
FTL. It's the only music I have on my PC right now, for the most part, since I lost all my music a year or two back after doing a format and have been too lazy to try and find it all again. As a happy coincidence it amazes me how many games FTL's music work with and make better. I have been having it play in the background while I play games various games it it matches up so well.
Persona 3/Persona 4 (Please don't make me choose) wins it for me as far as having a bunch of awesome songs go, but if we're talking soundtrack that best fits the game it is in, I would have to say Silent Hill 2. Fits the theme and the feel of that game fantastically, but the music itself may not be as viable to listen to outside of playing the game.
Mega Man 2. Every time I hear Wily Fortress 1 or Air Man, I feel the need to play it again. It's music that still sticks in my head, randomly, on any given day. The constraints of the NES really forced composers to create songs that were astoundingly catchy, and I think they blow most modern game music out of the water. Given the aforementioned limitations and considering the time period that it was made, I have to vote for MM2.
Well most of my favorites have been mentioned already. I will say that in my regular playlist of music Mega Man 2 is usually there when I'm working or exercising. I'm also a big fan of Castlevania music.
Oh and Super Meat Boy has fantastic music.
I have to throw out FFVII to be honest. I've been replaying FFVII for the past month, just was given the keys to the Airship finally. Anyway, the game really does have solid music in my opinion.
Also a fan of the music in Jet Moto, albeit there isn't much variety.