Well welcome to the Triangle. I moved down from Southern New Hampshire then to Northern Virginia. I left there in May 2016 and moved to Apex. Stayed a year and then my wife and I built a house in Morrisville but in the Durham County side. Im 2 miles from RDU Airport. Durham is a great place. Lots of different food choices, lots of street fairs/festivals, the DPAC which is the main choice for shows and concerts in downtown Durham. The American Tobacco Campus is really neat and in downtown. Durham Bulls, although they are the Triple A of the Rays, it is a great ballpark and I always go when Pawtucket (soon to be Worcester) Red sox come to town./ I too, am a big Sox, Pats, Bruins and Celtics fan. My Mets too though that comes from my roots in North Jersey. The PNC arena usually will have more Bruins than Canes fans in it when they come to town. It is a fun place though.
As for snow and wintry weather, usually up by Roxboro and Person county is the best spot in relation to the triangle for snow. Its a heck of a commute though, unless it doesnt bother you. Summers blow dead rats here. It is humid and hot from May to SEptember even into October. FAll is a short period here, though we do get fall color through Thanksgiving. Again its not like New England falls. Spring can be nice or cool and wet here. WE do get some good T storms here and the occasional effects from tropical systems.
Traffic isnt an issue here. Though people who live here say it is, but after living all my life in the Northeast, it really isnt that bad. The town of Cary actually has an acronym for it. Containment Area Relocated Yankees. Cary is basically anyone from the Northeast. Apex is more of a variable of people from the mid west too.
Pizza, I mean real pizza is tough to find here. I found one place that I have to pick up in Apex off Rt 1, called Big Sergios, they are from Brooklyn. Chinese food is well hard to find too. There is Chinatown here, like Boston and NY and DC have but it is tolerable for the food.
If you have any other questions let me know, glad to help