The question isn’t just how much affordable housing does your city have, it’s how much housing can you afford.
This excellent venn diagram from https://gizmodo.com/only-three-us-cities-have-good-jobs-housing-and-cultu-1781562314 demonstrates that, at least for people looking for work, it’s the intersection of housing cost, quality of life and economic strength that is important.
So even thought Detroit housing is very affordable, it fails in other significant ways to meet the test of where you would actually want to live.
At the other end of the scale, Seattle has both economic strength and excellent quality of life, but housing is expensive.
Ottawa has excellent job possibilities, decent housing (certainly the best value amongst all G8 capitals) and a fantastic
of life–except for one thing… horrible weather.