First off, your wife called it dead right. I have had the motorhome and, speaking strictly for me and mine, we wont do that again.
We have had various RVs in three decades. Over time we figured out the things we wanted the most. A walk around bed, a slide out, a roomy bathroom. Three biggies. Then, central air and all at a towable weight. Then, we wanted new or nearly new. Bought new. We don't enjoy the buying process, at all. So, we did our research and went looking on a Saturday, found a new unit on sale, knew it was a really good price, bought it right there, never looked back.
There is no perfect. We are pretty close to thrilled with our camper, keeping in mind 30 years of used RVs. See yourself in that camper after two solid weeks. What things are important to you for comfort and that fits your lifestyle. As we get older we basically want a small vacation house that we can take to where we want to go. We don't do extended road trips (at this time, maybe never). We go to our destination and stay the week. But, we could do a road trip if we decided. The last true road trip we did with an RV was pulling the old Prowler and that was in like, 1992-ish. It was amazingly fun and we had zero breakdowns.