There will always be people in every "category " (for want of a better word) that people will use as an example of what is good or bad in any situation.
I grew up in a council house. Working parents, solid house, great community.
My cousins grew up in a council house. Never worked, place was a tip, not nice community.
Neither are representative of everyone in social housing.
I left home, got married, bought a house, had kids. No council housing as most had been bought by then, and only areas available were places I didn't want to live.
I got divorced, moved out, ex kept house (long story).
Again, I wanted to live somewhere nice. No decent available social housing available around here, certainly not at short notice. So i private rented. Very expensive. My neighbours rent was half mine as a housing association owned their flat.
Didn't hate the neighbours. You win some etc.
Few years later, bought another house.
People just need to focus on their own lives.