I think you have hit upon the big advantages, having your house with you, even if it is your tiny vacation house, and not your main house, you have a thousand pounds or so of your stuff with you wherever you go, including things like laptop computers, your comfortable pillow, as well as stuff you probably would not bring with you if you were traveling by plane or even car, such as BBQ grill, bicycle, beach chair, and lots of things that don't start with the letter B. For those with medical conditions, the advantages keep going up, not hauling cpap machine around, a refrigerator to keep your insulin in, a kitchen if you have special dietary concerns, ...
The big disadvantage is cost, you will never or almost never save money vacationing by RV as opposed to staying in a hotel, there are just too many expenses to add up, even if you were to magically get the $20,000 - $200,000 RV for free, there is still cost of ownership (storage, insurance, maintenance, etc.), travel expense (fuel, rv parks, wear on tires, ...). Cost of ownership and depreciation alone for most people makes those seeming insane RV rental prices look appealing for those that plan to use their RV for less than 2-4 weeks per year, of course going the rental route means it is not going to be pre-loaded with all your stuff when you get ready to hit the road.
As to places to stay, scenic views, etc. sure there are the picturesque views, but there are also those overnight stops at gravel parking lot commercial campgrounds beside the highway, where the family of 5 next door 15 feet away decides to stay up until midnight watching the big game on their outdoor tv, or the long term resident guy with the diesel pickup truck and no muffler that warms his truck up for half an hour at 4 am.
We are currently debating taking the RV or taking the car on for a trip in May to Memphis for our nieces graduation. Let me run down the economics for you. Travel distance 500 miles each way, this is a long but doable 1 day drive in a car, not so much in an RV where everything happens slower, and is much more fatiguing to drive, in general we try to target not more than 350 miles per day our coach, maybe 400 out west with open roads, every time I have pushed past 400 I have regretted it the next day, driving 400 miles in a motorhome feels like doing 650 in a car, my longest day to date in the motorhome was 500 miles and 12 hours, almost to the mile and the minute with only stops for food and fuel. This would in effect add a day or so to our travel time if we take the motorhome. Then there is the money side, assuming we take my wife's car we are looking at about 25 mpg fuel economy, so 40 gallons of gas at $2.50 per gallon (maybe higher) = $100, if we take the motorhome at 8 mpg that becomes $312, assuming $100 per night motel, that is 2 nights right there. Then comes the cost of where to stay, the nearest RV park is 10-15 miles away from their house at $35 per night, given we are only likely to stay 2-3 days the economics clearly suggest we should take the car.
Let me leave you with these images of potential overnight camping spots where we have stayed for a single night. First the dream camping site, on the canyon rim at Goosenecks State Park, UT, then a typical (maybe little nicer than typical) roadside RV park, both out west, both dry camping, both cheap ($10) / free, photos taken about a week apart on the same trip.