I've tried just about every option except an Earth Crusier/Land Roamer/Custom 6x luxury house on wheels - okay there are probably dozens or thousands of options I haven't tried but here's what I have tried.
(warning - becoming an author has made me a very verbose old codger)
RTTs are great - and really annoying. Camping with friends? - RTT is fantastic, it's an excuse to let someone else drive - or mabye you're just staying put. I Have one, I like not having to find resonable ground, or tripping over guylines. Doesn't matter if the ground is wet, don't have to worry about bugs, and critters. I'm apparently a confirmed bachelor for life so it's just me - and maybe a dog (but not yet). At almost 62 I don't have to worry about climbing up and down in the middle of the night when a gallon jug works fine. For photograhy it's about as useful as shooting a 4x5 on a motorcycle (yeah I did that too). Make camp - sleep, get up 2 hours before sunrise, break camp close up the tent - pack everything and hope you make it to your spot for pre-sunrise. Alternatively - ignore sunrise shots, which is where I ended up. I'd have been better off with an RTT on a trailer - sometimes. In campgrouds I don't think it matters because I'm not leaving all that gear unattended. In the wild - no problem.
Back of a Subaru Outback- yeah, that's not happing again. It might have worked if that had been the plan and I was prepped for it - (see ground tents).
Back of the Jeep Rubicon Unlimited - much better than the Outback but has two of the same problems - in winter it's like sleeping in an icebox all that metal and glass just sucks heat away. You have to keep the windows cracked and it never fails - it's either blowing dust, rain, or snow (okay it's failed to do that a few times, but who remembers those?)
Back of the Pickup Truck - can be okay - a cot helps - a canopy would have helped too but I don't really like them. I'm thinking about adding something like (if not the) Leightner Active Cargo rack - and slinging a Blackbird XLC hammock with rainfly if I can get it to fit (just a thought at the moment). Self leveling, warm enough for winter camping (with quilts) cool with a bug net for summers. Easy to take down. Light weight - does require a full size pickup - or well maybe not I'm not sure - it's still just sort of a vague notion. Thought about one of those truck bed tents but - I don't know - the usefulness of the rack seems like a better choice.
RTT on a Trailer - very cool option, almost the best of both worlds - except more tires, more spares, harder maeuvering, and your still climbing a ladder, all sorts of storage space, more capacity for awnings, more battery power, just more... have not owned one, but I did nap in one.
Overland Teardrop - possibly better, as long as your not clostrophobic - no climing. You lose some packing space - what are you bringing all that stuff anyway? - most of the same issues as the RTT on Trailer. Have slept in a standard tear drop, not an offroad version but I like these. I wouldn't rule out the Oregon Trail'R Teardrop Alpha - but I'm not rushing to get one either (well, if I had my ducks in a row instead of spread out all over the place, then maybe I would)
Ground tent - hmm wet/muddy ground, no flat spaces, too many low branches above the only flat ground. Small tent - laying on the sleeping bag to get dressed, big tent - needs more flag ground - generally more overhead clearance. Coming back and finding something just shy of a tornado ripped your tent from the ground and dragged it though the thickets and now it's mostly shredded - not so much fun. Big tents can be really comfortable in a good spot. ground tents save a lot of weight and money. I Love big canvas tents - warm when you want them warm, cool(ish) when it's hot, lots of room - but a pain to clear ground, and a pain to pack wet, and a pain to dry out if you had to pack it wet. My Kifaru Sawtooth with Stove - great in the winter, pretty darn good in the high desert - sucks in the summer (can't seem to get enough ventilation.) and if the ground is wet - well - it has not floor so there you go.
4x4 Van - really cool, not a great dailly driver if you have a commute. Expesive. I came within days of Ordering a Sportsmobile back in 98 - Sort of wish I'd done it - but I just couldn't swing the cost. Really should have five years later when I could have afforeded it no problem.
Never tried -but wouldn't mind: 4x4 UniMog/Fuso/??? big overlander - major comfort, convenience, capabilites are extensive, so is the price and the mantenance costs.
Pick your poison. There is no perfect - there is just the potential for really excellent for how you do it.