A lot of people have already mentioned some of my favorite soundtracks:
The last of Us
FF7 and 9, most of the sung songs on 10, and Eyes on Me from 8.
Silent Hill, and a very specific one for the song "Soldier's Orders"
Metal Gear Solid, can't forget about Snake Eater, such a great theme...