I actually like this song from MGS3 the best because I used to watch a lot of old Bond movies and this just goes perfectly with the idea of a bond movie. Such an awesome beginning to a game.
Next is one from Ico, the only song I actually noticed during my play through, but it was just such a perfect end. Video contains spoilers so keep it tiny if you want to stay in the dark.
And last up to keep the variety going we have a battle theme. This is from Persona 4, and it fits perfectly with a boss fight in my mind.
...