As an old fart I am beyond any kind of tent. But as a young guy mountaineering, a tent was essential. With a young family, tent(s) were again the only affordable choice. When I got married, I assumed a room at the Inn I managed was a no brainer until I was told we were fully booked. So I rented a motorhome, 1980. Used it for the wedding night as well as a camping honeymoon. I've never considered a tent again.
Waking in a campground, watching everyone else scramble in the rain while I was brewing coffee in my shorts, my wife in next to nothing on the bed.... I was sold on solid walls forever.
To me RTTs make less sense and are less practical than an old fashioned tent trailer. Some of which are pretty luxurious. But the biggest drawback to an RTT on the SUV.... is needing to pack it up to go for groceroies or ... Even the ones on an Expo trailer with a ladder, why not just buy a stand up in tent trailer?
Right now, at 64 years old, I prefer cooking outside, I love a full mattress to sleep on and I like a solid roof with hardwalls. So the home built SquareDrop is how we travel. Pull in late, in the dark, roll into bed, go to sleep. Wake up to rain, roll out of bed and drive away. Our trailer is not airtight or water tight but in a rainstorm nothing gets wet.
We had the open deck trailer, I built the SquareBox, used an extra mattress, 6 sheets of OSB 12, 10' 2x4s, a gallon of stain, plate glass from a house we burned down. some gate hardware for hinges. All in with a translucent roof, $800.00. Plus the cooler, camp stove etc we already had. And it tows like it is not there. It will follow my Jeep anywhere. All for less money than an RTT costs.
Plus, end of the season. It all comes apart to store beside the shed. In less space than an RTT takes.
Freeing the trailer to be my pickup.
Some might think my comments are negative but the OP stated....
"Sometimes after spending a lot of money on something we’re reluctant to confess to making a mistake. We’ve heard some RTT owners, in private, tell us it’s like being a boat owner; the two best days are the day they buy it and the day they sell it."
ps, I bought my boat because I thought it was a cool project, a 1970s Simpson Sears package. I've used it once, the project will be complete in a few weeks and it will be for sale.
Just offering my prespective.