We've had the discussion a lot. I'll open it up like this. It is more than weather. Are you willing to think differently about government and taxation? If so, come on down. If you want to import Northeast govt. and taxation along with you, go to FL.
OK, now that I got that out of the way.
The Piedmont is still humid as heck right now. This is as opposite of San Diego as you can get. If you don't like humidity, forget it. And you will not get a break from about June 15 to Sept 15. It will be humid. Period. I call this our "winter." We enjoy summer for sure. Pools don't need heat. You can get out and enjoy mornings. You'll still need to wash that shirt, even for a morning walk. Just like up in the North, you can fight through the heat, or turn on the AC and enjoy inside.
Now, falls are typically glorious and long. I rake leaves until Jan 1, because most leaf drop doesn't happen until very late November and then December. That means that even November can be wonderful, with most days spent outside, eating dinner on our deck. So, mid-Sept to Dec is great. Last year was a bit of an outlier with too much humidity through all of October. That's not typical. October is usually a great month, and dry. Every few years expect a tropical storm. They happen.
Dec through Mar is liveable with many days in the 50s and 60s, great for golf. Sure, we get the occasional 30s too, with snow. Makes it interesting. April and May are fantastic. But if you don't like pollen, don't move here. We all become one color: yellow. No joke, you haven't seen pollen until you've seen Piedmont pollen. May and June are good and bad, depending on the day.
It is all variety. I've lived both in the Midwest and deep south Fl. The Piedmont is a great compromise.
BTW, Midpack may have some comments on a recent move. He did a lot of research.