Discover six metro areas primed for growth and six expected to weaken as affordability, climate risk, and more reshape the market