Mortgage rates need to drop significantly in expensive cities like Dallas, New Orleans, and Nashville to make housing affordable, while in cities with lower home prices such as Pittsburgh, Birmingham, and Detroit, rates could rise above 6.7% and still remain affordable. Some markets like New York, Los Angeles, and Miami remain unaffordable even with near-zero mortgage rates due to high home values.