I grew up in NC and spent up to the time I was 30 in the Raleigh / Durham area. It use to be really nice back when I was a kid but much of the piedmont area has just gotten too populated for my tastes (same can be said for where I am currently stuck north of ATL but hope to move to "fly over country" in the next few years where there is still a little elbow room to be had). Lots of ground is being chewed up by development. you can still find land to hunt but as with other states in the area, it has become a lease / hunt club situation in many areas. Land prices in many areas are also really high, which is great if you own some as my parents do, but might make it hard to buy any decent size acreage.
You may find it is a veritable paradise, so take my somewhat jaded critique with the understanding that I have seen the area I grew up "ruined" (in my opinion) by too many people and too much development. If you move their I hope things work out well for you.
Plenty of deer, turkey and used to be some great bear hunting on the coastal plain years ago. Even starting to be some hogs on the coastal plain. I remember reading about some huge black bears in some major hunting magazines that were being killed in NC. Also looks like they might get Sunday hunting passed soon.
Good Luck!