I don't know how this piece became a staple of horror film music, but it is often used as a theme for the big baddy.
I just use the opportunity to post this masterpiece. Maybe someone can explain what makes it terrifying?
Blitzkid (being horror punk) has some great horror-themed music. This one makes me think of Heathcliff digging up Catherine's corpse in Wuthering Heights: