Where has it been successful, and what counts as success in that? I genuinely do not know.
Primarily Vienna. There's nothing complicated about what Vienna did - other cities just prefer to please billionaires instead of providing services to citizens.
Basically, all of Europe post-WW2. A significant share of new build in the 50s-60s was social housing.
It's been exceptionally successful in Singapore, for one.