Glad to hear others have thought of this actual car camping idea and it’s not totally off the wall, LOL!
We have a Honda Pilot and while my hub is quite tall I think we could fit if the seats out down!
Colorado_mom - that picture of the RV on Trailridge Road makes me sweat just looking at it!
We have done cabin camping a number of times and I love it! So much easier than tent. The trick is (as you said) to find those affordable, not-yet-reserved spots. We usually book a year ahead for ours.