I know with mine it's always been love/hate. A few really big pros over a bunch of cons. It's very situational and personally, some trips I couldn't pull of without it, others it's a complete and utter pain.
My pro RTT example, sometimes I do multi-day trips and every day I move on to someplace new. Almost like touring I'd guess, usually no hard core off road trails but I'm not stuck to pavement. However, every night is a new spot. The RTT shines for this. For one it's very comfortable, I sleep as good as I do in my bed at home, so on longer trips that becomes very important. I have a tent-cot and hammock setups, and they are great in different respects, but neither are as comfortable and after 4 nights in that, you are going to start feeling it. While not effortless, setup is pretty easy and there is not a lot of folding and sorting gear. Bedding stays in the tent, tent folds, put the cover on, and go. With experience and a system, I've gotten it to be a 10-15 minute thing tops. For self contained on the go travel, it's great.
My con example, already discussed but several times a year I like to spend weekends in different places. 3-4 nights, in one spot. I quickly start to hate my RTT on these trips. It's a whole different mindset folding up a tent and breaking camp when you know that night you'll be back. In these situations, it would be so nice to be able to leave camp set and go run around freely and come back. I've also taken up mountain biking, and add that in the mix and it becomes more of a pain because then it starts to interfere with your other plans for the day, and breaking or setting up camp starts to become a chore you must do before/after you do the fun thing.
For me, a ground tent is all but out of the question. Last time I was in a ground tent, it poured rain, and I woke up as I always did with one, nearly floating on my air mattress on a dry tent pad. While I recognize my own inexperience, methods, and quality of gear might have contributed to my discomfort, I prefer to just find a more solid solution, and said screw this, never again. I just don't like being on the ground, if it's wet, that is where the water is, and while I'm not overly weary of bugs and critters, I don't like them having handy access to me all night. You get off the ground and things just get more comfortable.
So for me, being off the ground, and easy setup in relation to ground tents covers most of the cons. But on the cons, having a RTT on your vehicle is not a happy situation. It's heavy enough in a bad spot that it does affect handling and ride comfort negatively. It is a dead flat wall, 100% air resistance, and hits fuel economy. It's a pain off road, the extra height make low hanging trees a problem, and any off camber leans feel a lot more sketchy.