I found myself in need of social housing when my dd was a baby and I was a lone parent. We first went into a B&B, we had one room with a bed plus a shower and toilet and a shared kitchen.
It was a scary place to live. There were spot checks to make sure you were spending the night there, and you had to sign in morning and night. We were there for almost a year.
I was then given a temporary studio flat. It was riddled with mice and was in a really rough area. We stayed there for about 8 months.
Eventually we were allocated a Housing Association property. It was a lovely 2 bedroom flat but in the worst possible area, a really bad estate in South London. Back then if you refused the first property there were consequences. The rent was cheaper than private rent and it was a secure tenancy. Repairs were dealt with (eventually) and I considered myself very lucky, I had a secure home.
However I felt utterly trapped, the anti social behaviour on the estate almost gave me a nervous breakdown. The only way I could move was to get a swap, no-one wanted to swap to a crime ridden sink estate!
I gave up my secure, low rent tenancy and went into the private rental market. I live with the possibility that I could be handed notice at any time, it's happened once already! However, if I want to move then I can, I have some control now.
Council and Housing Association properties can come at a price not suited to everyone.