Nrass mods make such a huge improvement on game play. When I first started loading up on expansions and everything (before finding mods and maintenance tips) I found the Sims 3 to be unplayable because of how buggy and laggy it was. And it really astounded me how a game that old could run so bad when much much higher end games ran so smooth. With the nrass mods I've noticed a massive improvement, and I use a batch file to do maintenance (I made this by following a tutorial form someone here on the forums to delete the 5 cache files by using just one, I just added a few other files to the list that are recommended to regularly clean out).
That aside, here is my expansion pack list of most to least:
supernatural & seasons I honestly can't decide which of these is more important, so they're in first place together. I tend to make certain characters in every sims game, and my favorites are a family of sorcerers, so supernaturals to me are very essential.
Seasons adds so much more to the environment that makes the game feel more alive and I absolutely love it, plus the plethora of new activities isn't bad either.
World adventures
Growing up my favorite games in the world were the tomb raider series (I love archaeology and ancient cultures, so it adds a tiny pinch of that). World adventures felt very tom raider esque to me. The first time around I was super unimpressed with this pack and shelved it for awhile after I played it. The second time around however I stuck it out a lot longer in terms of investigating ruins and quickly fell in love with the pack. It's safe to say this pack will never be shelved by me again.
Generations
This expands gameplay so much if you're a family simmer (which I am). The objects and new features are super enjoyable.
Island paradise
I love this mod in conjunction with the nraas traveler mod as I can visit the tropics on vacation without having to move there. I also really love houseboats, mermaids, and diving.
Pets
I try so hard not to love this pack, because I always wind up spending a lot of time picking up strays, cleaning them up and naming them, and giving them to Sims around town (if I don't keep them myself). The pets are adorable and the amount of effort that must've gone into some of these animations is staggering. It's just a beautifully done pack.
Ambitions
This one took me awhile to get into (and if I must be honest, I still have a lot of stuff to test out), but the more I explore the content the more I love it. It adds a LOT of stuff to do and a lot of stuff I make regular use of.
Least played:
University life There really isn't anything wrong with this pack, I love a lot of the objects in it. I just haven't had the time to sit down and enjoy the full experience of it, and it seems like there is always something keeping my main family from utilizing the university features, so I haven't really gotten the chance to test it in full. I think the main reason likely is that the Sims I play most had just started a family at the time I got this pack so I'm more involved with raising the sim kids than sending one of the parents off to college. I plan to start a new save once I finish my most recent CAW project and will make sure to use university when i do.
Late night
The vampires were fun, but overall I just didn't get too into the features of this pack. I use some of the objects in it regularly, but not many of the actual features. And the celebrity system drives me up the wall. There is no reason a stay at home mom should have paparazzi and autograph hounds stalking her. It eventually got to the point any household I play regularly has the security fence to keep this irritating stalkers out of my yard and away from my poor sim family.
Into the future
Again, nothing wrong with this pack. I used to time travel on my main sim when she was younger (sometimes with her dad tagging along since I didn't want my teen sim running around unattended in the future). However once she moved out on her own and started having other adventures I just gradually used the time travel feature less. Plus now that I have the nraas traveler mod I have so many vacation destinations it's just less interesting to spend time in the future. The main reason I do so at all anymore is to check on my descendants. Even if I find them to be monstrosities I like seeing how they're doing, and if they're having a hard time I try and help them out by giving them a makeover or polishing up their houses if they're living in hovels.
That aside, I do love the collectibles and plumbots, I still have the plumbot my sim built when she was younger.
Showtime This is my least favorite expansion so far. The only reason I got this pack was for the singer profession and karaoke machine, and the price at the time was dirt cheap.
The online interactive features and achievement system were buggy and very unappealing to me, and I came into the series way too late in it's life span to have used it much anyway (most likely anyway). I also didn't utilize many features of it.
Well that's the end of this rambling post!