If you are interested in content that includes both vampires and the gothic themed stuff, you would be better of getting Sims 3 and Supernatural together than Sims 3 and Late Night. While Late Night introduced the vampires and Supernatural just included them for those who didn't already have Late Night, most of the extra content in Late Night is more night-life oriented in general than geared toward the vampire aspect.
There is some occult-specific stuff. What comes to mind to me are the witch items like the broom and the wands, and the fairy houses. I'm not sure if the vampire altars were included in Supernatural or they were only in Late Night, since I already had Late Night when I installed Supernatural. I don't think werewolves have any specific items, but it's my least favorite occult from that expansion so I've hardly played it and might be wrong.
There are also a couple of gothic themed sets in the Sims 3 store, which you might want to look for on the daily deal or use the bonus 1000 sim points you would get from registering your game. Grim's Ghastly Manor and Midnight Hollow as a store town would go well with the vampire stuff.