I can't believe no one has mentioned Michael Smith's song "Vampire". Claudia Schmidt recorded a bang-up version of it early in her career. It's the most haunting song I know for this theme.

Buddy Mondlock has a fun song called "Skeleton" about a skeleton in his closet. "The Unquiet Grave" is good too.