You have to be honest about every aspect of the costs of owning an RV, not the just the nightly fees.
A $50,000 RV depreciates by at *least* $25,000 over the first ten years of ownership. Let's say you do 5 weeks a year for 10 years, or 50 weeks. That is $71 per night of use just in depreciation. Then if you consider upkeep (tires especially), storage, gas, propane, repairs, insurance...and don't forget the costs of outfitting the RV to begin with: bedding, cookware/dishes/silverware, storage containers, road items like hitches, ramps and tools, and then you have hoses, sewer treatments, etc. It all adds up, and they are all items you don't need if you are hoteling it.
Motorhomes are the worst, but even if you are towing a trailer with a vehicle that you already own and use for other tasks, it is difficult to justify RV ownership on the basis of costs, when you add in ALL costs.
Even full time "van life" people are discovering that living in a $100K+ van conversion driving all over heck is an expensive way to live when all costs are considered, way more expensive than a $2000/mo apartment.
We love camping and are looking for a new trailer, but we are realists about the costs - RVs are definitely a luxury item.