So I've had limited camper experience, but I've had some, as well as tenting experience and I'll tell you this. With the yard work etc, cabins have their fair share of work with yard work and upkeep - but campers and tents are a ton of work to arrive at, set up, take down, etc etc etc. All the lawn chairs, awnings, outdoor kitchens, etc need to be set up each time you camp and is a lot of work (especially with young children). That on top of booking the sites, making sure you got what you want in like May or whenever the site opens. We have a cabin. Its on the water. We arrive, unload our cooler, and go sit down outside on our deck, on the water, fire going within minutes... no setup. AND I can say that our cabin (which wasn't really expensive) has appreciated to more than twice what we paid for it. It's on the lake so we can drop our boat in when we please. Even on a seasonal lot, a camper still depreciates and typically you don't own the lot. In my mind, the cabin is an easy choice. Grab a tent or whatever if you feel adventurous but if you find a place you love, a cabin will pay you back in whatever you pay for it. A camper, not so much. They're prone to leaking and while it's nice when they move, I've mostly seen that those with seasonal lots don't give them up (because they're established and usually sort of sought after) so they don't haul their camper anywhere anyway.
Long winded, but in my mind the cabin appreciates in value and is less work overall. No hauling trailers, packing and unpacking sites, etc. And others are right - a bad day at the lake beats a bad day at home!!