I've been to a few campgrounds that offered an escort; Smithfield KOA in Four Oaks, NC (we've only ever done an after hours check-in, have to call someone to register and they escort to site - don't know if they escort during the day), New Orleans KOA (the one that survived Hurricane Katrina), the Lickdale Campground in Jonestown, PA (before it became a KOA - only offered escort the first time we stayed there) and Tropical Palms Resort in Kissimmee, FL.
I thought it was a nice touch, but it is not necessary. I don't think the price dictates the level of service. At the time, not including Disney World, Smithfield and New Orleans KOAs were the most we ever paid for full hook-up camp sites. At the time, Lickdale was one of the cheapest full hook-up sites. Tropical Palms was between those.
I've never been to a campground where I couldn't read the map and figure out where we were. I would expect if you asked for an escort at other campgrounds, if they weren't too busy and had the means to do it, they would have.
Now that we own a Motorhome, we only use campgrounds for camping. If we are just stopping for the night, we are in a Wal-Mart parking lot. We did that a couple times in the travel trailer, but the weather had to be just right. I can't sleep if it is too hot and my wife can't stand being cold.
I like the idea of campgrounds offering low cost sites only for over-nighters, but if the price isn't pretty close to free, I wouldn't bother. I have my own A/C and heater and the generator to power them. I also have holding tanks and can take a shower in my motorhome if need be. So too much more than free won't be worth it for us.
-Michael