There are places where social housing works. In the Netherlands social housing is often quite pleasant, especially if it is centrally/well located. A difference might be that there is much more of it in the Netherlands, so the middle-classes also often live there (especially early in their careers).