I can give you a few great state park campgrounds in NW Ohio- Harrison Lake, Maumee Bay, & Mary Jane Thurston. All three are very nice, & the rates are decent. If you choose Harrison Lake, it's not too far from Sauder Village and would be a less expensive option than Sauder Village CG. Wineries & golf courses are nearby, along with decent sightseeing.
In Kentucky, check out the Land Between the Lakes area. Lots of good camping options there as well. The other side of the state has the Cumberland Gap, which would have some great sleeping weather in the fall.