If you like occult and multi-generational family play, I'd definitely make Realm of Magic a priority. Spellcasters are pretty fun, and since you can become one OR be born one, like vampires, but they aren't immortal (like vampires) you can play a whole dynasty of magic users if you want pretty easily. It's pretty flexible too--you can make magic your sim's life, or just dabble, or ignore it completely--and of the game packs specifically that I've played, aside from parenthood obviously, it's probably added the most fun elements for me in terms of playing multiple generations.
University's pretty good, it's a nice addition to family play for me, giving something extra to teens aging up and becoming young adults, BUT it's a little tricky, cause you really have to focus on the sim going to university for them to do well there, and if you move them out/into the dorms, you end up spending weeks and weeks JUST on them while neglecting the rest of the household. I've ended up using mods to shorten the amount of credits needed to graduate, or turning off aging while going to university, or using mods to pretty significantly extend the length of life stages, since otherwise, as sim lives aren't all that long, university ends up eating into a big chunk of that life span, both for the sim in question AND any other sims left behind. It's an okay pack, I like elements of it a lot, but in my experience, it's utterly unplayable without mods.
I'm not a big fan of Strangerville, as there's not much to it besides the linear story line, and as such I haven't managed to integrate it into the rest of my game very well. Besides CAS and build items, I honestly barely use it in most of my games. I played through the mystery once in one save and that was about it, unfortunately.
Aaaand, those are the only packs of the ones you mentioned that I have, so I can't really speak to the other two. Hope that helps at all!