You're going to get opinions that range from worst game ever to best game ever and everything in between. I'd suggest purchasing the base game and trying it out for a day. You can request a refund within 24 hours of first launching the game. If you don't like the foundation then no number of expansions is going to guarantee a satisfying experience.
You also might want to check out some reviews on YouTube. LGR is a respected reviewer in the sims community.
His take on the game:
"If you're looking to try this new sim game, and want my subjective opinion, here it is. The Sims 4 is fun. For what it offers it pulls it off without too many problems. But as it is on launch, its not enough for a long time simmer like myself. I would recommend just holding off until the price comes down quite a bit. I think you'll be happy that you did."
https://www.youtube.com/watch?v=ohwbklm3w_E
He also has reviews of all stuff packs, game packs, and expansion packs.
https://www.origin.com/usa/en-us/store/great-game-guarantee
I believe the base game is only $7 on Origin so now might be the time to try it. :)