What do you recommend?

I was highly sceptical of Strangerville before getting it. The actual story is probably just 1-2 hours if you focus only on the story. I weaved in regular life gameplay, with my kid sim starting the investigation and didn't solve the mystery until he almost turned adult. So I got 4-5 hour gameplay out of it. In fact after I solved the mystery , I started a new family with a sim whose is a tree hugging politician who thinks the “mother” is part of nature that needs to be saved so his goal is to restore the the strangeness of the town, and the cycle continues :)

In fact I feel like I will replay it with a different mix to the story , eg vampire or spellcaster + Strangerville etc.

Yes eventually you will get bored of it but it is true for most packs.

Outside the story, the military career is decent with work from home option. The town is really nice. I do like the listening device I think I can use it in my storytelling gameplay.

It is a very unusual game pack unlike others I am glad I gave it a try. I hope you will like it too.

Ps I don’t even like stranger things after season 1 :)

Well I enjoy both ROM and Strangerville. I'm still using them, both.
First ROM...because I like making spellcasters. They are over-powered but I think it's fun to be able to do housework and copy things and make plants spring out of the ground, a bunch of the spells are fun just to use in daily play.. especially if you like to make things easier for your household or make things harder for others.
As for Strangerville. I mostly never play with the storyline that comes with it. I love the world itself it's.. strange. I like seeing the military there almost like its occupied for whatever reason you might decide to play it that way. I enjoy playing possessed sims also. They have certain benefits like all their needs fill after their possessed state... so basically your sim never has to sleep. I can use it in multiple scenerios and have. I like offering the fruit to other sims too.. lol. Pass on the wealth!
So just saying if you like craziness you can get it with both packs eventually. Especially if you actively play your sims.

I think as a legacy player you should think about getting University also. I've personally never tried to send multiple sims to college at once though and I understand that can be hard to do, but it adds to normal and somewhat realistic play for that period of life. I like things like servo more in the long run but am still now and then sending someone to Uni. I really like that you can go from home also and that you aren't locked into any particular place until they are done.

Discover university is acceptable with 6 or 8 credit mod. I hope mc command will add a feature for us to change the credit to anything we like soon. I can only play uni for max two sims weeks not more than that !

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!

Moschino is good for taking portraits of family members to put on your walls. That's about all I use it for and I'm happy with my purchase.

I am finishing Strangerville now for the first time. My plan is after solving the mystery I'm going to have the hero's children grow up and open a diner in town and just play the family that way, then have one of the grandchildren get curious about the family hero and go poking around in forbidden places and accidentally start things up again as a teen. Multi-generational family play is my thing, so that's how I hope to keep things interesting after I finish the story once.

I haven't gotten very far into Realm of Magic yet, and don't own the others myself, so that's all I can recommend.

I love occults, but I enjoyed Strangerville more than I enjoy Realm of Magic. If you like crazyness, Strangervilles is the craziest of all. I only solved the mystery twice (for different outcomes), but I still play in that world with new saves even with all the crazies twisting about (I don't mind them, but a lot of people do and I completely get how they could be annoying).

I like Discover University a lot, though you'd think there'd be just a bit more family play involved. Sometimes parents randomly show up to visit at the dorm (though my college student never has time to hang out with them lol) and there's the occassional call from the parents to come visit and once you're there you get the "Hang out with family" prompt, but that's all there is to it, I think.

Tiny Living has that relationship boost to offer if you don't need much space for your family.

And Moschino doesn't have too much offer on those fronts, but I love the build items and the photographer career (the jobs are actually interesting and fun to complete) if that's anything you'd be interested in.

Thank you all for your help! Ive just bought a bundle and i went with Discover University, Strangerville and Moschino. Sooner or later i will get the others though. Im just always half to a year late :)