In places where social housing works, the government builds enough new, shiny apartment buildings to keep the market rent low. Obviously, the construction of apartment buildings MUST FIRST BE EASY AND LEGAL for the government to do this.
Turns out that when you build something that's not particularly nice when it's new it becomes unattractive as it ages, which creates unattractive high-crime neighborhoods. Great to solve housing, but very unattractive for anyone else in the area. We basically stopped building them
At least in the US, a lot of the popular "historic" building types like the New York brownstone had a midlife period where they were deeply unpopular and ill-maintained.
This makes sense. Owners, even poor ones, will do their best to maintain their housing; less wealthy owners especially would know that they're likely stuck with their unit and should do their best to keep it comfortable. Renters have no incentive to (it might even be illegal for them to make improvements), and landlords are unlikely to cut into their profits if they can avoid it.
I would say that policy which encourages long-term renting - per-property, as well as per-renter - is deleterious to the socioeconomic fabric. The majority of a housing unit's life should be spent inhabited by its owners, and the majority of a person's life should be spent in a house owned by themselves or their family.
To give the example, brownstones became unpopular as it became apparent their designs resulted in high heating and AC bills since they were pretty drafty and poorly insulated. Only when they blossomed into being "historic" did people start valuing them enough to start fixing the problems and restoring them.
Further it’s not housing that creates poverty, and thus crime ridden neighborhoods. Somewhere is going to be relatively poor and thus both poorly maintained and crime ridden. Cities have seen the exact same building go through cycles of poverty to prosperity and back.
So a "crime-ridden" neighborhood or "slightly bad" people perhaps relies on defining crime narrowly as things that poor people do