A mix of TS2 & 4 as I have minimal experience with 3. TS2 does have werewolves, so it's entertaining revenge to turn Daniel Pleasant into one. Its vampires are restricted to turning folks, not the rest of it, so largely ignore them. The Contessa has a great gown for lady sims, though, so have often gotten creative in getting it for my ladies that are into older style outfits. Not a TS2 game goes on without at least one sim (usually several) getting into the magic one way or another. Found great CC that is tailored to magic users, and that game provided secret bookcase door is ideal for setting up hidden lairs.
TS4 has the best vampires, end of discussion. For some reason have not done much with TS4 magic, though such as have done has been fun (especially roasting Vlad). Perhaps the lack of activity is the feeling that it could have been done better, is somehow incomplete.
