I can't speak to every single city in the US, but in Chicago, Detroit, and near me in Atlanta--all areas that I've lived in--public housing has been badly underfunded, has been allowed to decay by the city, and is often so bad that the buildings end up being condemned. Most US cities seem to trend more towards public-private partnerships, where the private company mismanages the property, and the city fails to take enforcement action. One of the largest public housing projects in Atlanta has finally been condemned and seized after something like two decades of mismanagement and lack of care in enforcement from the city. (And yes, Atlanta is nominally a Democratic city, although I sincerely hope that Andre Dickens and the entire city council that's supported Cop City all die in a fire.)