First off, welcome to N.C. When you say upstate NY do you mean just above NYC or really upstate New York.
I was born and brought up in Plattsburgh, NY just 25 miles or so from the Canadian border. Moved with my family to Vermont when I was 15 years old. Lived there for the next 48 years before retiring and moving to just outside of Raleigh. Both my children and their families moved here also. One in Cary and one in North Raleigh.
They all came here with no jobs within the last 5 years and within a couple of weeks were all working at jobs that not only paid well but were right in their wheelhouses and everyone of them had a completely different wheelhouse.
As a retired person I looked for a part time job to occupy my time, and found one on the first try.
As for the important part, from my front door to WDW is a 10 hour drive. Not a hard drive either. I do stop for meals and just to stretch my legs and other things.
As for traffic, how you would see that would depend again on what you mean by upstate NY. It can get heavy at times, but, I have seen a lot worse (Boston comes to mind) The road conditions are very good. It does get chilly at times but I don't believe it has been below 25 degrees since I moved here 3 years ago. Snow... total accumulation in those same years just about 3 inches... pretty much gone the next day. The only thing I regret is not coming down here sooner. In those same three years the temperature has not even hit 100 degrees in the last two.
Golf every month of the year... ain't nothin wrong with that!
By the way... Cary, NC is the ideal place for us northerners to move to because of what Cary stand for...
C ontainment
A rea for
R elocated
Y ankee's
Just a joke, of course, but, it does provide the natives with a wealth of chuckles.