I find vacations are better if you do a little editing of the vacation worlds.
I added a natural looking pool in Granite Falls so I can pretend they can swim in a lake, and a restaurant with a game room upstairs for rainy days. You're not likely to send multiple households on vacation at the same time, so you only need as many rental lots as you want variety. I have a romantic cottage, a family cabin and a campground. There is not a lot to do in Granite Falls specifically except collecting bugs and plants and fishing. Sims can hike, but not together. And stargazing/cloudgazing came with OR I think too. I like the campfire interactions although they are way too likely to catch chairs or benches on fire. The world is beautiful and there is a hidden area that you access similar to the hidden lots in the base game.
In Selvadorada I built up the resort area by adding a playground and picnic area to an upgraded museum lot I downloaded, added some games and a dj booth to the cantina, and downloaded a spa lot built with Jungle Adventure BB items. Some of my sims spend their entire vacation just in that area, learning the culture and trying the foods and learning to rumbasim. Again I went with one romantic and one family rental lot. I haven't made over the trailhead neighborhood yet, because if I send sims there it is to explore the jungle. I have enjoyed exploring the temple a few times, but there isn't just a ton of variety from trip to trip, so I try to space the adventure trips out. It is handy to have the tents and coolers from Outdoor Retreat for exploring the jungle. There are a variety of creepy crawlies and curses and blessings you can run into while exploring. The world is even more beautiful and does provide a few unique harvestables and fish species, in addition to the relics you can collect with the archaeology skill.
I don't see that National Park lots do anything special. In my game I use them for natural areas that I don't want my clubs that meet at "any park" to randomly visit.