As an aging widower (lost my wife five years ago) I've found my best social connections have been on cruises and group tours, rather specific locations. The first two years I tried RVing, found social connections too hard to make, being the recluse in the RV park or campground too easy to do.
I've found as one of the singles in a larger group, people, even couples, will pull you in. And since widowers are rarer than widows, there is always a lot of curiosity about who you are and what you might be. On tours and cruises I've met a number of people with whom I've found common ground and maintain a connection on social networks.
So it is not so much a place, as an social environment. The right RV park can also be the right environment, but I would think that would be a long term locale like a snowbird resort, rather than tourist destination where everyone is a transient.