You sound a lot like me when I first retired and started out. I found many RV parks to be disgusting places where I could hear my neighbor snoring, blue tarps and old cars, people getting up at 5:30am to go to work, poorly maintained...etc.
That's when I got to work fixing up my rig to boondock.. lots of solar, big inverter, lotsa battery, a way to carry water. You can find many state parks and places just outside of a city that you may find much more appealing than RV parks, but you won't find full hookups and it will be a bit more work. If you can avoid the full hookup need you'll be able to find much more desirable living.
Of all the negatives of an RV park, I found listening to people's vehicles idling at dawn to go to work the most depressing.