Having a similar domestic situation & having done all three (hotel, camping & RV) methods, I can give you some bullet point highlights:
1. Unless you're paying for the very best (read: most expensive) hotel room with a great view, outdoor patio, etc, you'll be spending all of your time outside in a public park, hiking, etc, or in the common area, just to avoid the sense of wasting your vacation inside a room. After awhile, you can begin to feel rootless/homeless, so while you may want to just chill in your own private abode, the "it's beautiful outside and here I am inside" angst begins to get to you again.
2. (Car) camping - with all the fixins' - is the cheapest, most flexible, and easiest way to go. But ... there's a ton of packing to do beforehand, then you have to set-up camp when you arrive, then you have to break-down camp when you depart, then you have to unpack when you get home. (I used to feel like I needed a vacation when I got home. LOL)
Secondly, even if you've gone to all the effort to make your wife happy, warm & dry, there's still gonna be:
- her midnight pee walk to the campground bathroom
- her shower in the campground public shower
- nothing to do after it gets dark/cold in the evening except go to bed (campfire is fine, but soon enough ...)
- dark/cold in the morning, but someone has to get the stove going to make coffee, etc
- a lot of exposure being outside all day long - we have a pop-up shade tent and even then you can begin to get too much "outside"
3. RV. RVs are expensive - as mentioned above, even the small(er) ones are pricey. And that's only the beginning - maintenance is a killer. The best description I ever heard was "a house undergoing a constant earthquake". All that household plumbing, electrical, appliances, etc gets shaken to hell driving down the road. And since the loads are heavy, the engine, drive train, spring, shocks, tires, etc are all under stress. Did I mention sales tax? A $50k RV has a $4k sales tax.
The alternative to getting a new(er) RV is to get an old(er) RV, but then you're dealing with a lot of repairs; it's OK if you know how to work on cars. This is what we did, but since I've rebuilt/restored a few cars since I was a teenager, I generally knew what I was getting into. If you need to rely on a mechanic, then it will eat you alive.
On the plus side, RVs give you (read: your wife) a "place to be". You can sit at a normal dinette table, someone can be napping while the other is watching TV, reading, chilling, etc. There's a frig, so you don't have to keep getting ice each day for a cooler, there's an internal stove, so you can make coffee without going outside, there's an internal bathroom so "someone" doesn't have to go outside ... (Are my hints about "someone" registering? LOL)
However, the number one thing I love about our RV is this: you can get a sense of being outside in your own space while being inside. In other words, open the doors, windows, awning, etc and you literally feet/inches away from actually being outside, but without the constant exposure from really being outside. IMO, this is key. It's one thing to be worked while backpacking, but in a domestic situation, you (or that certain someone) are looking for that balance of getting outdoors, but not being "homeless".
On that note, I should add that one thing I never appreciated was having 'somewhere to be' between the 11am (check-out) and 2-3pm (check-in) hotel/camping witching hours. With an RV, you can just pull over to any old turn off - oftentimes a beautiful vista - and chill. With either car camping or hotel, you are definitely homeless, with an overriding desire to get checked in and settled.
One last thing about an RV - all your sh!t is already packed. Bed, clothing, chairs, shade umbrella(s), etc, etc, etc. This is a very big deal, something you may not appreciate until you no longer have to do all that packing when car camping. Set up and take down is practically non-existent. That means you can make decisions on the fly to just pull over and check someplace out. We did a trip to Zion & Grand Canyon a few years ago. On the way home, we decided to spend the night on the Colorado river below Laughlin. Pulled in late, backed up, cracked a beer (or two). Here we are minutes after parking (see the smile
?): Edit: see the wife in clean, white clothes?