I own all of the expansion content worlds. Of those...
I think Sunset Valley and Riverview are nice and underrated, although I get why they wouldn't quite top anyone's list.
I didn't spend much time in Twinbrook; nothing really wrong with it, but it didn't compel me to play it with what was already there before it.
Bridgeport is nice, and the only actual city in the game. The only thing I didn't care for is the non-city areas seemed a bit dull, and the map overall felt too dark and drab (which may have added to the former feeling). I wish apartments were done in a way to where each building had more than one (it'd be nice to visit a neighbor, or even one on another floor), but they were still a nice alternative to traditional lot homes.
My play time with the expansion pack worlds post Late Night is more limited, but I've loaded each up and spend a bit amount of time exploring them. I actually liked the look of Isla Paradiso (but heard it can cause lag issues), and I say that even owning Sunlit Tides. They compliment one another well for having somewhat similar themes, but Isla Paradiso feels more modern and less "vacationy" to me.
I own two store worlds, and am interested in four total (maybe up to six, but four are for sure). Of those...
Those would be Roaring Heights, Sunlit Tides, Lucky Palms, and Dragon Valley. I have the former two, and will get the latter two. The other two that are "maybe" are Lunar Lakes and Lucky Springs, but leaning towards probably not unless I really get the itch for something wildly different setting-wise with the former (I have yet to explore In the Future's world though!). The rest don't interest me much at all.
I got Roaring Heights and Sunlit Tides together, and started in the latter first. I already know I'll like Roaring Heights as I loved Bridgeport, and I love the time theme they did with Roaring Heights. The only thing that sounded disappointing to me when researching it for reviews was how the buildings are shells, and not like the apartments in Late Night. It's not a deal breaker for me though, and I understand they did it to make it workable for those who don't own Late Night.