Affordability constraints are testing buyers’ limits, even at the upper end of the market, and the steepest drops are taking place in desirable areas.