As home buyers continue to seek affordability, metros in the Midwest and Northeast are luring ever more of them, according to a realtor.com analysis.