I've stayed overnight at Woods and Waters, think it would be adequate for a few days, but the setting is not really like a state park.
We tend to use the terms campground and RV park interchangably, probably because so many RVers do like to be in wilderness-like campgrounds with full RV park amenities (full hookups, paved pads and patios, cable TV, Internet, restaurant, convenience store, swimming pool, LPG service et al).
My experience is that this just doesn't happen that often. Even the family-oriented destination chains that call themselves campground (or Kampground) are more like RV parks, and the "improved" or "modern" RV sections of public campground tend to be more like the RV parking lot than a place you would want to camp for an outdoor experience.
So you have to choose, trip by trip. If you want camping, you are likely to choose a campground, but not have all the amenities of modern life. If you want your little patch of suburbia as a temporary location for your home on wheels, this will more likely be found in a RV park.
Sometimes you will find almost the two things together, but not very often, and it will usually be expensive (thinking of Fort Wilderness).