I am partial to supernatural elements in my game, and buy the packs for that reason. I also like the risks the Murphy Bed, and Vending Machines created too.
For the Supernatural, I bought the packs when they were on sale. I was disappointed to found out that some elements got nerfed by the time I got them. Like Get to Work had alien abduction nerfed, which was part of the reason I bought the game. Vampires were nerfed, and can no longer break in like they did. People who didn't want the break in could've just locked the door to them. It was something I did for Sims I didn't want to b Vampires. Yes, Vampires still visit too, which may be an issue for some people, but you can just ignore them and not invite them in. Also, I did spot Vlad in my Sulani world at night, but he is an NPC, and I thought it was hilarious to see him there. RoM was given the option for your Sims could ride brooms, or use wands, you could turn that on and off, and their magical realm doesn't even really exist to affect gameplay. Only mages and Sims who want to become mages can really access it, and even then you have to use a glimmer stone to get there.
As for the nerfing of the Murphy Bed and Vending machines, that kind of takes the fun out of it. I don't have a Murphy bed yet, because I knew the risk since Sims 2, so I chose not to get it in Sims 4, problem solved. As for Vending machines, it was a fun little thing to do to see what would happen, it was scary/hilarious when the Vending machine fell on my Sim, but she was fine. I actually liked seeing that, because it adds fun to the game.
I opted out on packs I didn't want, like Eco Lifestyle, and Journey to Batuu, and don't have all the packs. I really want to get Paranormal stuff pack, and if the gameplay gets nerfed, it would really not be fair for anyone that bought it. Overall, there isn't really that many occult packs, and that is one of my favorite parts of the Sims franchise, so I want to have a occult pack that doesn't get nerfed for "realistic" gameplay.