One North Carolina city is surging while the other cools down. See the 2026 housing market comparison between Charlotte and Raleigh to find your best investment.