Nox Arcana has great Halloween mood music. Their last CD, Carnival of Lost Souls even has a rock track hidden in the end, but they are more instrumental with a storyline that goes along with each cd..
http://www.noxarcana.com

and if you think they sound similar to (but better than) Midnight Syndicate, you will want to check this: http://www.legionofthenight.com to learn some truly scary stuff.

Also there's some cds on Amazon that are soundtracks from old movies.