Oh I KNOW I've got an imbalance, but this made me curious about how big it is, so I counted.
Top lot type is restaurants at 15 lots.
I get a lot of use out of them, and will make them multi-purpose. Usually with a cafe attached. I'll also have at least one or two restaurants in a world because I like to have more of a cheaper family place, then a more fancy upscale place for events or dates. I also like having different kinds of restaurants like Italian, seafood, Asian Fusion, Mexican, American, etc. San Myshuno has the most at 3 restaurants, with a diner, a family/cozy rooftop restaurant, and a Very Upscale rooftop restaurant. I don't experience as many problems with DO as some others do, so I don't have an avoidance with them, and it's a decent group activity.
Second highest is bar at 8 lots.
I don't usually use bars as actual bars though. I find they're a good lot type to use to make movie theaters. Based off the lot requirements, it encourages sims to buy snacks, then go watch a movie. I'll also put some game stuff in there and some vending machines. My bar lot in Britechester is a multi-purpose bar/theater combo.
Parks tied with bars at 8.
This one actually surprised me a little, since I feel like I don't go to parks all that often. But I do like having them. I've started making them change with the seasons so there's different activities. And in certain worlds like Granite Falls, I've added "ponds" for sims to swim in. In Brindleton during the warmer weather there's a music stage and some food trucks. My park in San Myshuno is massive and has...pretty much everything (a pool, a basketball court, a greenhouse, a playground, a dog training course, lots of places to hang out, that fountain you can play in, and places for sims to graffiti or busk).
4 Cafes.
This number would be higher if I didn't multi-purpose so many cafes into my restaurants. And one of my cafes doubles as a park. I actually use that lot a lot. I have a cat cafe that allows strays so I can pretend they're supposed to be there/sims can adopt them. And I have an internet cafe where sims can use some computers or are encouraged to bring their laptop or do school work.
3 Karaoke bars.
I'm surprised this number isn't higher honestly. I've got 2 in San Myshuno (a lower-scale private room one, and a HUGE one with a big stage and then private rooms on the top floor), and one in Mt. Komorebi. I plan on adding a multi-purpose karaoke/movie theater combo lot to Copperdale (hopefully, if it works).
Then I've got 2 lounges, 2 museums, 2 vet clinics, 2 spas, and one mall. These lots exist either for necessity or because I feel like they fit in a certain world. I've got museums and lounges in Brindleton and Del Sol Valley (and that one is necessary), vet clinics in Brindleton and Willow Creek, spas in Del Sol Valley and Sulani, and a mall in Oasis Springs. I don't really use any of these lots.
EDIT: OH I forgot nightclubs!! I've got a few of them but I'm surprised I don't have more. My club in San Myshuno is a really cool rooftop place with a main dance area, bar seating above the dance area so sims can look down, private rooms, hot tubs and a pool with deck chairs for sims to lounge on.
Travelling always feels like a hassle honestly, so either my sims homes provide most entertainment, or I need to make my community lots really appealing to get them out of the house. Having variety with my lots helps that. Also making them multi-purpose helps a ton.