I’ve grew up in one. While it’s not as nice as a single family home in Silicon Valley climate it did create tons of affordable housing.

Most places are screaming for densification these days so your argument seems even more wrong.