Social housing and housing benefit are two separate things.
I have rented privately in the past and needed housing benefit, I now rent from social housing and pay the rent from my wages, with no housing benefit.
The 'bond' was much cheaper than a private rental, and after 12 months of not going into arrears with rent, it then became part of my 'account' and available to use as rent - I used it when I needed to during furlough/losing my job to prevent me falling into arrears as much and have now built it back up.
My HA is non profit, and as well as providing affordable homes to people with long term tenancies, it provides jobs to local people, amenities like play parks and sheltered/supported housing. The rent I pay is ploughed back into that and slowly, the community is improving. But this house isn't mine for life, the tenancy is, but I can request to or be asked to move when appropriate, I keep the tenancy (providing I pay rent, am not anti social and want to) but can move within their properties that are available, according to need.
I'm treated better, as in fairly, and like a customer paying for something I use, rather than treated like the LL is a paragon of virtue 'allowing' me to stay in their property in return for a not insignificant amount of money. Things are repaired in a timely fashion, so I'm not left months with no heating and hot water that I'm paying for, or holes in the roof leaking in water and out heat, and not made to feel unreasonable for wanting what I pay for.
I'm not going to have 2 months to find over £1000 to put a deposit and first month's rent down, if I can find somewhere else that is in that time frame, because the LL wants to realise their investment and sell.
I pay a bit less than the 'market' price, but, I also get less. There was no flooring, the place was filthy and there were several minor repairs that needed doing when I moved in, and I'm responsible for things that you aren't in private rent, or in fact aren't allowed to do like decoration, plastering walls, changing flooring, external fences etc.
They also didn't refuse to take me because I was a single parent, or part of my income made up of tax credits or because I have a poor credit rating.
I'd much rather the money I have go into this HA, and benefit the whole community I live in, than someone's pocket to be honest. I'm grateful to have it, but I got it because of the circumstances I found myself in, and was allocated on need and am lucky enough to be be in an area where there's enough social housing, and was able and willing to live a bit more out of the way to have the upsides described. And they have a good tenant who pays the rent on the property.
I can't afford private rent, the prices have gone up beyond that of my wages, I may well need housing benefit to manage should I go back into private rent.