Hey i liked U3 OST, but Castlevania: Lords of Shadows, Heavy Rain, AC2, FF13/13-2 had the most memorable soundtracks in games imo. Oh and i'm only including PS3 games on(in?) that list.
When I take into consideration my favorite Soundtracks, I generally put a series as a whole. The Uncharted series always had music that fit well based on the scenario. I couldn't really just sit down and listen to it, at least not all of it. Most video game soundtracks I appreciate in the game, and can't really get into it outside of the game. I love Uncharted 1, 2 & 3's soundtrack but I can't listen to them practically. Devil May cry 3, and Skyrim (basically all remakes from Morrowind), Portal 1 & 2, inFamous 1 & 2, Littlebigplanet 1 & 2. Those are just a few, but I can't listen to them outside of the game. At least most of the time. The only soundtracks I can just open up iTunes and listen to while I do homework or clean would be from the Final Fantasy and Kingdom Hearts series.
Clicky clicky dis link to be scarred for life (Updated with more poison for your eyes!)