I've been thinking of doing this as well. I recently cleared some of my property and made a campsite that I listed on hipcamp. So far no takers, but was also thinking about listing it on airbnb with the camper to increase my options for rental.
Me personally, a site like this is something I would be interested in even if a bit more expensive than a normal CG. 1/3 acre waterfront campsite in north Florida on the Santa Fe river near the Ichetucknee river. Over 20 major springs within 50 miles with paddling, swimming, tubing, and cave diving all around.
I need to look into the airbnb thing again, my big challenge will be getting the DW to allow strangers in the camper.