> The act of concentrating affordable housing is not desirable and easily forgotten about.

We know how to plan this properly. Mistakes will no doubt be made but there is no reason to think they will be this obvious.

Almost everything you describe is the effect of a housing shortage. The new houses wont happen overnight, it takes quite a bit of time to create a surplus.