We have been to one campground in CA with "partial hookups" - only a water faucet and 120V 20A AC buried in tall grass along the perimeter of each campsite. Each campsite was spread well away from it's neighbors - probably each campsite taking up at least 1/2 acre.
That was "nirvana" ... it felt like ultra-quiet boondocking combined with enough hookups to stay for days in complete comfort rain or shine, hot or cold. Some of the campsites were completely shaded. Many of the campsites were right by a lake filled with fish, too. Your boat could be moored overnights in the shade of trees on the shore closest to your site easily walkable to/from your site.
That's my kind of camping with an RV .... but extremely rare.
As far as dry camping with a generator is concerned .... we have two generators along with us: The built-in Onan for serious RV power, and a small discontinued generator quieter than modern Honda EU generators for charging of the coach batteries every 2-3 days. For just about zero-noise battery charging without relying on the sun, we idle the non-diesel main engine with it's alternator charging the battery bank.