You really will have to try out a few different types of camping places to see what you like.
RV resorts often have amenities (for example: laundry room, game room, organized activities) and full hookups, and charge accordingly; to me they feel like small cities of RVs, and I camp to get away from the city!
State parks vary from state to state, and range from FHU to no hookups.
Corps of Engineers (COE) CGs will usually be near water, so they tend to have beaches, boat launches, and large, well-kept sites (fees are 1/2 off with a recreation passport, and in another month I'll turn 62 and apply for my $80 lifetime card).
State and national forest CGs are generally rustic with no hookups, usually tucked away in the woods and sometimes on a small lake, and tend to have shorter sites that might not fit a large RV (which is why I prefer towing a trailer shorter than 20', so I can fit into these more remote places).
Then you have the boondocking, where you just find some public land that allows dispersed camping and use a nimble rig (like a 4WD truck topped with a camper) to get in and stay a while, far from civilization where you might not see another living person the whole time you're there.
Mike G.
Liberty is meaningless where the right to utter one's thoughts and opinions has ceased to exist. That, of all rights, is the dread of tyrants. --Frederick Douglass
photo: Yosemite Valley view from Taft Point