Like, moderately expensive areas that are medium density, so that they exacerbate the housing crisis but aren't particularly nice to live in?

Indeed. In fact, unaffordability is the whole point. Main problem with the affordable housing is that it attracts the people who seek affordable housing.