One of the great things about camping is that there are a zillion ways to enjoy it. Get an RV directory like Trailer Life or one of the others and scour it for places you may want to go. You can find anything from extremely rustic no-hookup backwoods camps all the way up to 5-star resorts with private golf and multiple pools.
One of the best things about camping is that you can make a destination trip or you can camp on the way to a destination. We've done it both ways and each has its merits. So, whether you have a weekend or a whole month, you can always find something to do.
This past summer, our trip was from our home in So. Cal to Washington state. Even with the cost of gas this summer, it was a reasonable trip. We averaged 11 miles to the gallon (including over mountain passes). Had we flown, it would have cost waaaaay more than the $1,500 total we spent for the two weeks for our family of four. That's under $27 per person, per day for travel, food, and lodging!
If we have a long haul day, we'll make sandwiches before we leave our campsite and head to our next spot. Then when we make a pit stop, we'll bring the sandwiches up from the fridge to the car so that we don't have to make an extra stop just to eat. With as many trips as we've made to Washington in the RV (5 or 6) we've gotten really good at this. Our furthest trip was to Alberta.
And one other benefit to an RV. . . . When someone in the car suddenly announces they need to use the restroom - NOW - you can just pull off to a safe spot and send them back to the RV.
No more disgusting gas station bathrooms!