You mentioned avoiding busy areas but also wanting to be near water. I avoid staying around water because I don't boat and water attracts people making for crowded campgrounds.
Loving state parks really doesn't give much of an idea of what you are looking for when you camp. How do you want to spend your time when camping? Are you looking for scenic areas? Enjoy hiking? Looking for photo ops? Enjoy relaxing at the campground (and watching water)? What do you plan to do when the weather turns bad? Dress appropriately and venture forth or stay in the RV or under the awning? Do you want to visit urban areas, museums, attractions, restaurants? Do you want/need hookups? Shower facilities? Do you want to travel with reservations or be more spontaneous and flexible? Do you need cellphone/internet access? Do you want to camp in one area for an extended time or do lots of traveling?
Before asking campground advice you probably need to be more specific. You also need to have agreement with your spouse as to what you are looking for when you go camping. If not in total agreeement there needs to be some compromise.