Here's my take on rentals. If you don't have time to use the RV 30-40 nights per year, renting isn't a bad deal compared to the cost of ownership. I am not saying it's cheap, but neither is owning.
I was a long time tent camper until I got caught in one too many rainstorms and I bought a cheap used pop-up. That was six years ago and we've loved our pop-up but I'm tired of taking it down in the rain now that I'm back on the East Coast. I would love a Class C but I've run the numbers and just can't justify it. My new strategy is use my pop-up for weekend camping within 100 miles of home and rent a Class C for 10-14 days in summer. My annual cost would be $3,000 to 4,000. I can't own one for that price, especially to watch it sit. I don't look at the rental as throwing away money. It's just economics until I'm closer to retirement and can use a class C more.
By all means check out cabin options or consider tent camping but don't rule out the RV as a bad deal if you can afford it.