Have you heard the soundtrack of “Atonement”, it’s quite clever how they incorporated typing sounds (something that the main character was doing a lot) into the soundtrack, and the way the choir blends into the score in the beach scene, is brilliant!
Can’t deny the effect Bernard Hermann’s score has had on the impression of Hitchcock’s “Psycho” - every time the shower scene is mention, it’s accompanied by the shrieking sounds of the violins.
Hans Zimmer has done some great scores, plus composed a libretto for Dante’s La Vita Nuova especially for “Hannibal” which has a very moody, dark and romantic score.
There are a lot of great composers. Gustavo Santaolalla and “Brokeback Mountain” and “21 Grams”, not to mention James Newton Howard and Cliff Martinez, and check out Bear McCreary’s score for Battlestar Galactica - I haven’t even seen it but the music is amazing. :)