Charleston, South Carolina, nabbed the top spot, backed by a strong middle class and jobs in defense, aerospace, and auto manufacturing.