I say it is pretty worth it, I got my copy on sale.
I bought it for the Vampires, but it does have a Goth/Occult vibe going for it.
There is a new world, it isn't the biggest world, but I do enjoy it.
You get a power grid, and you can either have your Sim get bitten to become a Vampire, or create one in the CAS. Also to note, the Vampire power gird thing was used for Werewolves and Spellcasters in later packs.
The main NPCs are Lillith, Caleb, and Vlad.
One thing is a tutorial you current Sim could be bitten, so to avoid too many Vampires you can lock the door to them.
I wanted Vampires, but with Vlad on the loose, I ended up locking to doors to the Vampires, because he kept biting my Sims.
I overall enjoy the pack, because I love the Occult packs, but you can still enjoy it without the Occult.