Depends on the area. I work in social housing and some of it's very nice (new builds, good neighbourhoods) and some areas can be quite rough and crime-ridden.
Social housing is not all about projects and low incomes; it's about affordable housing. For instance, we provide affordable housing to keyworkers such as teachers, nurses, police officers, etc.