It is interesting to read different experiences people have from different parts of the country.
We are used to state parks with only dump stations.
Until recently, here in Connecticut no state park had "full hookups". Actually, I'm not sure if any do even now, but more CT parks have been installing water and electric the last few years. A lot have dump stations, usually just one lane. A couple big state parks have a large dump site area with multiple dump lanes. A lot of the CT state parks have shared water spigots between sites, not to "hookup" to, but to just fill your camper's fresh water tank and then you disconnect from the water faucet.
Having said that, my favorite CT state park, Macedonia Brook, has no hookups, no dump station, no paved pads, no running water - the available water supply is literally a couple of hand pump wells. Park "bathrooms" are outhouses. Camp sites are huge, and every time we've been there it was very quiet at night. I think the lack of amenities keeps the partiers away - which I prefer, now that it is just wife and I camping.
Some private campgrounds are very much "party" campgrounds - we go to those if we are camping with a group. When our kids were young we often went to resort-style family campgrounds that were busy and noisy - kids enjoyed all the activity.
Find campgrounds, state or private, with whatever facilities that you want, that you enjoy and go camping!