When people talk about this topic, people get into big debates about it because they are thinking of 2 very different kinds of low-income places.
These are common in large American cities. The problem tenants are a minority, but the landlord lacks the usual incentive to address them since the building will always be full, since it's below-market. The landlord may also be a social benefit organization that's politically disinclined to evict.
Non-market housing tends to go badly in the USA, including programs closely resembling those that have succeeded in other countries. The reasons for that are complex, though I strongly suspect that the weak mental health system (many of the worst problem tenants would be institutionalized elsewhere) contributes.