If you're not able to find a good match in the Asheville or Tri cities area...which are my 2 preferences over anywhere else in the country....
I know you mentioned Roanoake at one point---that's musky heaven, along with world class smallmouth, and reservoir stripers....
With some amazing geography, friendly communities, and mtn trout opportunities as well.
I think the flat terrains of Raleigh and Charlotte would be putting you in bass and catfish territory with a hefty drive to the clear water.
I'd make a break for the mountains and hill country if possible---greater variety of drainages to fish and hike. Less traffic too.