Here is my list, I have them all, except My Wedding Stories so I won't rank that in the list.
1.) Vampires
2.) Werewolves
3.) Realm of Magic
I am an occult fan, so I tend to rate these packs higher, regardless of actual gameplay.
4.)Parenthood
5.)Jungle Adventure
6.)Strangerville
7.)Star Wars: Journey to Batuu. Still hate that this is a theme park pack, and overall just a cash grab, but it went up higher after being used to create Sims based on a book series I liked that took place in ancient times, which were the robes.
8.)Spa Day. Not going to lie, I just bought it for the Elsa looking hairstyle.
9.) Dream Home Decorator.
10.) Outdoor Retreat. Kind of really not much to do, but I like the camping stuff, and plan to do a off the grid, or rags to riches with a Sim someday.
11.)Dine Out. It came with a set I bought, haven't actually played it, because it seems to always be buggy with other players.