The works of Akira Yamaoka for the Silent Hill series are excellent because not only do they add to the game itself, but are great as standalone music. They are very diverse and just great pieces of music. One of my favourite artists.
That being said, I also think Alan Wake, GTA: San Andreas, Resident Evil 2, and Metal Gear Solid 3 had great music as well.