I'd be really nervous about a $7k diesel pusher, honestly. That's about the bottom of the market for a decent gasser with no slides from what I've shopped.
Now, maybe it's because I just haven't spent any time in anything else, but I don't think the P30 is completely fraught with peril. Yeah, the 454 is really thirsty and its power is a bit underwhelming for the chassis, but it's not the end of the world. I've towed through the Smokies with a car on a trailer and as long as you have a little bit of patience, it's not all that bad. Yeah, it wants to tram a little bit, and every time a semi blows past, you will get pushed to the shoulder and then sucked back in, but it's not that much worse than a van pulling an enclosed trailer. If you're shopping for a bargain, I wouldn't dismiss it out of hand.
As far as mileage, I've got the Banks powerpack on my TBI 454 and I've put 19,305 miles on it while stuffing 2,593 gallons of fuel in it since May 2016, for an average of 7.44. Now, some of that fuel was burned in the generator, and a couple trips saw reduced mileage because I had a brake caliper that was seizing up. On my trips to the Rolex, once I get past the mountains and am going through Georgia and Florida where it's a bit flatter, I'm seeing around 8.4-9. When I'm towing the overall trip average is more like 7.7 when I take out the generator usage. The trip to Canton from Cincinnati and back (no towing) was 7.6. Gulf Shores and back (no towing) was about 8.2 and there was generator usage while out on the road to run the rooftop air.
That said, pretty much any motorhome built on that chassis is going to be absolutely hateful to try to live in. At the era that the P30 was phasing out the manufacturers were phasing in slides in a big way, so most of the P30 chassis that you'll find will not be so-equipped. What we've found in the last 6 years is that it's the narrowness of the coach that really makes it feel small along with the low ceilings. The ceiling height is a mind thing, but the fact that you can't pass anyone in the hallway and the fact that when the couch is in "bed mode", you can't enter or exit the coach because it's blocking the door make it somewhat tiresome. You can live with it for a short trip, especially when you're spending most of your time under the canopy outside, but when you're cooped up in there, it wears on you a bit.
In the used class A space, I'd lean towards the newer Ford chassis with the 6.8 V10. They used the 2v version through 2004 and the 3v until whenever they stopped putting that in the F53 chassis. DPs are going to be very spendy for a good one on initial buy in or they're going to be very spendy in deferred maintenance on a bad one. Both with be spendy for ongoing maintenance. The 6.8 on the F53 or the 8.1 on the Workhorse will get the job done for you though. If you want to pull your very large trailer and/or a very large car, then the DP will be the best at that, no doubt. Plus with the engine in the back, it's a much quieter drive down the road and if you run the genny, it'll be a quieter night's sleep since the genny will be in the front instead of under your bed. I'd go gas and just buy a smaller car to flat tow with a Blue Ox setup. As I understand your requirements, the goal is to stay for longer periods of time at a single destination, not spend lots of time eating up miles going from place-to-place with short stays here and there. So bias your decision criteria more on what it's going to be like to live in it and less on what it's going to be like to ride in it.
One last thing to think about, especially when you're looking at older coaches, is that you're now dealing with a whole system of parts that are made cheaply by different people, intended for occasional use, and spend a lot of their lifetime going through cold/hot cycles and bouncing down the road. The good news is that the various parts are not tremendously expensive if you can afford to wait on Amazon or another internet retailer to ship you something. But mobile RV services are expensive because they can be. Some things are easy to find anywhere and super cheap - the thermostat for the water heater, for example. Other things are not. People will try to sell you an RV with a cracked windshield. Those are about $1,000 per side, so budget accordingly and make sure you have glass coverage on your insurance. Control boards for appliances can be replaced easily if you shop the Dinosaur Electronics catalog - weirdly, the exact same control board that I put in my water heater will work in my furnace. You're going to become a mechanic-appliance-repairman-roofer-glazier-carpenter-plumber-hvac-tech and the older the coach, the more of that sort of work you'll need to do. Your water heater will never die at the end of a trip, the furnace will never go out when it's just slightly chilly, and the fridge will never stop working when you don't have a fresh load of groceries in it. The older you go, the more of this you'll have to fight. It can be a bargain as long as you're willing to tackle that stuff yourself, but if you intend to call in the pros to handle that sort of thing, it will eat you alive.