Several people have mentioned the parking lot types. Like everyone else, I usually prefer a little more character and landscpaping, myself. But, one of the most unusual, and one of the neatest (for its purpose) spots we ever stayed was in downtown St. Louis, about a mile from the arch. Basically, they tore down a warehouse in a business section of town, exposing a square city block. They installed the plumbing and wiring, and then just paved the whole thing. There was about a 3' border of grass just inside the fence. There was a small office/store/shower room, with a swimming pool on the roof! The campsites were only about 14' wide, so basically, there was another coach about 4' or 5' away from your entrance door - there wasn't room to put up an awning. It wasn't exactly the best part of town, but it's right across the street from a police station...
But, we were there for a trade show, on the same weekend that March Madness basketball was in the arena, and the place was absolutely full. The city bus stopped right outside the gate, and you could travel anywhere in the city for a buck. It was close enough that we walked back from the convention center one afternoon.
Not exactly a typical RV experience, but since then, I wish every city had something like it! As an urban "campground" it was perfect.