We are in a park in the Kawartha's. Been there about 8 years.
As previously stated different parks different rules different atmosphere.
All in we pay about $3000 or a little better per season. That's site, 2 boat slips, seasonal guest pass, seasonal fire wood pass, one winter boat storage plus metered hydro.
I think all parks are extra extra extra.
We like it. Friendly park. Not cliquish ( unless I'm in the clique and don't know it. But I don't strike me as that kind of person). Good mixture of lots of kids and older couples. Pets welcome just not on the beach. Probably 120 trailers.
Owners are young couple with 2 young kids of their own.
Absolutely engaged in the park. Seem to do one major improvement every year.
But in my opinion the trailer is not an investment. They depreciate. We bought new and moved it in. At this point I'd be happy if I got half of what I paid if I were to sell.
Also when it gets old enough it may be worth nothing. Lots of parks have age restrictions when it comes to selling a trailer and keeping it in the park.
As already said shop around. Stay a weekend or two see how it feels.
Park we are in has rentals by the week or night.
All in all it was one of the best things we ever did.