I try to avoid places with a lot of long-term/ permanent residents.
They are a small community - and some resent folks using up 'their' facilities. You will get the same attitude from locals in tourist towns once get outside the tourist trap strip.
Can't always avoid such. My son-in-law lives in Fort Lauderdale, and unless we part at the COE park west of Okeechobee - we have to stay at such a park. Two weeks max, and I'm gone. (His development covenants don't even allows us to pull the TT into his home area at all.)
One tool I use when looking at places to stay is Google Earth/ Google Maps. If I see what looks like a lot of 'park models' in a RV park - I'll look elsewhere.