I have never taken an RV vacation, nor spent any night in one. I have also been debating with myself regarding getting a class B/C or a small travel trailer. It is a different mode of travelling, particularly for a long trek cross-country, something I like to experience.
Regarding cost, it appears that while lodging and meal costs are lower, the fuel price may be a large offsetting factor. Hence the attractiveness of a class B. And then, one cannot forget the maintenance, operating, and depreciation cost.
I think for us, the advantage would be the ability to be on the road for months at a time. We have found that we cannot be perpetual travellers. After many trips, we have found that, for us, the duration limit for living out of 2 carry-ons is two weeks before we miss home. Well, on a road trip, as we can take more with us, we may be able to go for a bit longer. I am hoping that even a small motorhome or travel trailer would allow us homebodies to feel somewhat cocooned at night, and able to extend a trip to a few months.
I don't know yet, and am just guessing. The rental fee of a class C for 1 month is from $4000 to $5000 for a 3,000 mi trip. It is not cheap, so I think I am better off studying the best I can, then hold my nose to buy a used one. Shorter trips to test the water might not be a valid "stress test" in our case.
PS. My wife never complains about cooking. In fact she enjoys it. In recent years, I have also learned to cook. So meal preparation is not at all a chore for us.