The bubble mostly affects new home buyers, which are the ones who need the least protection.
Rent is inflation-adjusted and can't be raised at will, so there is a very long delay between market prices increasing and most tenants actually bearing the cost. Everyone living in social housing still has a home, and won't be evicted so that another person can come in to pay 2x the rent. Seems pretty good to me.
I don't know much about Detroit but it seems to demonstrate that the simple supply-demand model does not reflect reality. Prices should have dropped significantly, but instead it followed the same curve as the rest of the USA, with those $500 properties being a localized phenomenon.