Every single time you meet someone and tell them where you are from they will say "Oh really? I/My brother/College/Sister/Parents are from NY/CT!"
NC is great because despite the large amount of northern transplants the state has kept its southern culture. Make it a point to go to the coastline, make it a point to go to the mountains, and go to the areas surrounding NC as well.
One of the biggest differences I've noticed being from NC and having gone to school at UConn is that people from New England are routinely amazed at what people down here consider a "short" drive. My girlfriend came to visit last year and I told her we were heading to the beach. When I told her Wrightsville Beach is 3.5 hours from Charlotte she was shocked. People down here consider anything ~4 hours away to be a "short" drive.
Lots of friendly people. Fayetteville is near Ft Bragg therefore there is a HUGE military presence.
Good luck and welcome to the state. Haven't met a person yet who has made the decision to move to North Carolina. Between the weather, people, cost of living, and culture people seem to really enjoy themselves.