We have an example of affordable (for the tenant) housing.
It is called prison. The problems in prisons would continue in most other ideas of affordable housing. At least prisons mostly contain them to the tenants.
Note “most other ideas” does not equal “all ideas”.
Prison for being homeless?