I like that one part in Snake Eater where Volgin drives the SHAGOHOD out of the river, and then the MGS theme starts kicking in, and you're all feeling "hell yeah!" and then sometime later, Eva kisses Snake and if you push R1, you can watch it in first-person mode and feel really, really gay--I really liked that part.
Voodoo Vince has some really good, jazzy tunes. And the music on Silent Hill 3's intro is wonderful. That's about all I can think of right now.