1. Vampires - The party never really gets started until the vampires arrive.
2. Dine Out - I love taking my sims out and restaurants are such a fun place.
3a. My Wedding Tartosa Stories - I love weddings, but this one is all about the world. It took a bit for it to grow on me but it's my favorite now.
3b. Werewolves - I love this pack and I could easily put it ahead of MWS, but at the moment I'm getting more use out of Tartosa than I am anything in this pack. If only it had come out about 6 months or so sooner I might be working on a SimLit story about werewolves instead of a romance novelist living in Tartosa.
5. Dream Home Decorator - Like others have mentioned, the CAS and BB with this pack are essentials in any situation where I'm going CC free.
6. Spa Day - This is a pack that might be taken a bit for granted. It's not necessarily a pack you really spend a lot of time thinking about and yet when you do think about it you find that you've used it more than you realized. Or maybe it's just me.?
7. Jungle Adventure - What a shame Selvadorado is only a vacation world. It's one of the most beautiful worlds in the game and our simmies can't call it home.
8. Parenthood - I don't do much family gameplay so I don't get much use from this one. That will change eventually with my current story saves so if I did this ranking again, say a year from now, it might be much higher up the list.
9. Realm Of Magic - The pack that disappointed me most of all. This one is a love it or hate it pack. I feel like they missed the mark with what could have been the best of the occult packs. The spellcasters feel like normal sims with some cheat codes built in. Maybe it was the fact that they chose to call them spellcasters instead of witches. I wanted to love this pack but I'm still waiting for it to pull me in. Maybe someday it finally will.
10. Outdoor Retreat - I tend to go really long periods of time where I forget this one exists. I've only been to Granite Falls a handful of times since it came out. This is one of the packs I got because I kept finding lots I loved that needed bits and pieces of it to get the look. It's probably a case of just never having the right story where this pack could shine.
11. Strangerville - The Mother storyline was fun the first time through but it does get old after that. Like Outdoor Retreat it's a victim of the kind of stories I tend to tell and I haven't come up with one where this world would fit in.
12. Journey To Batuu - I love this pack, but even I'll admit it's super niche. Where it shines is as a bit of escapism from realism or occult gameplay. It certainly doesn't hurt to be a Star Wars fan either.