How about a houseboat rental vacation?
Railton
I looked seriously into that this year, but, like everything else, if you didn't book it last year, you weren't going this year.
We rented a trailer a couple years ago through RVezy.com and it was a great experience. Just like AirBnB or Turo, but for RVs. Prices are all over the map, but it's definitely possible to find some excellent deals. It'd be a really smart move to rent a few different sizes and layouts to see what really works for you / your family before springing for buying one. Or for that matter, if you even enjoy doing it.
A friend of mine bought one a few years ago and he detests towing it (and he's been towing 'toys' for years). His fuel consumption is shockingly bad, it can be a pain to squeeze them into campsites, and finding good provincial park spots these days is like winning a lottery.
***
Regarding Bob's point about not wanting to sleep where someone else did, just replace the friggin' mattress, you boob! You'll want a decent memory foam one anyway instead of the newspapers and sawdust that come with those trailers in the first place.
We're thinking more about a cottage or getaway property these days. A properly built one shouldn't require an inordinate amount of maintenance, and if you think an RV won't, guess again. Winterizing them can be a pain, too.