Where to begin...(song names are links...)
Repo! - The Genetic Opera: Something about the music in this...most I can say is that it moves me - in that "slaughter the room" mood, though I'd never really do it(I would write, it however...). The best ones are - Legal Assassin, Night Surgeon, and At The Opera Tonight...
Silent Hill: A town that feasts on your fears, your emotions, and is going to put you through your own version of hell...Not to mention the monsters - if they really are monsters...
SH3 - You're Not Here, Breeze - In Monochrome Night
SH4 - Room Of Angel, Tender Sugar
SH-SM: When You're Gone, Always On My Mind
Queen Of The Damned: Mentioned in another thread here(obviously), and the music for it, wow. Namely those done by Jonathan Davis for the movie, and the various others who performed them for the soundtrack.
Slept So Long