Not going to happen in US cities. Literally every person actually living in a city knows this, which is why many people protest having public housing built anywhere near them.
Many Americans claim to like European welfare state, but they they don’t seem to be aware as to what it takes to get there. One most obvious thing would be to tremendously raise taxes on middle class (who bear the brunt of the tax burden, unlike in US, where tax is mostly paid by the wealthy), but another thing is more ruthlessness in enforcing social norms. Nowhere in Europe you can just sit on the sidewalk and shoot up heroin: you’ll be arrested, put in rehab, and if you persist, jailed. Psychotic mentally ill who scream obscenities at passer-byes are involuntarily committed. Tent campers are arrested and forced into shelters. None of this is happening in many UD cities, which claim that their policies of looking the other way, or subsidizing the underclass lifestyle, is “harm reduction”, and continue to repeat that as number of people living this lifestyle is not reduced, to the contrary it keeps growing.