Hello! Sounds like the Greenville area could be a good fit for you. More retirees are discovering the Upstate of S. Carolina for easy access to the outdoors (parks, greenways, mountains, streams, lakes, etc) and very reasonable cost of living. This region has a true 4-season climate. Although summers can be hot and occasionally humid, they probably don't hold a candle to the misery indexes of Florida's summers. Greenville proper is a very walkable city, and most crime tends to be hit or miss-concentrated in predictable areas of town. About the same as many cities, and better than most. The town of Walhalla in Oconee County has an annual Oktoberfest as well.
Due to the long-time presence of the Michelin North American headquarters and BMW's sprawling facility nearby (plus suppliers and even some European textile companies before that), there is a noticeable European presence in Greenville. We have a Dutch "brown cafe" (pub) and a Belgian restaurant downtown, as well as a couple German restaurants in the area.
We do have spiders a-plenty, and snakes do inhabit this region, but we've never had pest problems in our house in the 11 years we've been in it. There are two 55-plus communities that I'm aware of that you might be interested in - The Cascades at Verdae Cascades Verdae | Greenville South Carolina Independent Retirement Living
and The Woodlands at Furman (University) Greenville Retirement Community | Upstate SC | Woodlands at Furman
. Neither is adjacent to downtown, but are not too far away either. The Cascades is near a Greenlink (local bus system) stop on Verdae Blvd I believe.
You'll probably want to post these same questions about the other cities/areas you mentioned in those forums on city-data to get accurate info from the locals.