I would only partially agree with this sentiment. Take a look at this great site (
Affordable Housing Design Advisor) that lists profiles on high quality affordable housing projects nationwide. They include total construction costs and funding sources for exceptional affordable housing examples across the country and even have a special section for "green" projects.
Go to the "gallery" tab and then scroll down to see a list of places shown. They include many high-cost and desirable cities including Austin, Seattle, San Francisco, NYC, Santa Monica, New Haven, etc. A great resource for people in the affordable housing arena and some really amazing examples of very well done projects.
But your point is well taken in that publicly-funded workforce or affordable housing projects are often used as catalyst projects to try and rejuvenate rundown parts of a city. On the one hand, this approach can feel like "well, let's just see how it goes - first we'll house poor people there and if it takes off, more development will come in." On the other hand, this kind of housing can provide quality housing for people already living in hard hit areas (and who may be renting from a slumlord in a substandard home), effectively improving the quality of life for folks who already struggle with living in neglected parts of urban areas. If done well, this seems like a better alternative to gentrification which often displaces the lower income sector and moves them to another location rather than improving their lot.