We have stayed there for short periods of time and enjoyed it. Naturally, we weren't involved with management or the majority of residents as we were there to visit with friends and play pickleball.
For long-term use I think you'd need to actually stay there a season and talk to owners, explore the rules, etc.
For us, the sites were too close. Plus, there are a lot of Park Model trailers. Many folks aren't bothered by this so you'll have to judge for yourself.
Good luck!