I think it depends very much on the estate.
Many years ago I had to use social housing for a couple of years & was offered somewhere in an area that had the reputation of being incredibly rough, people said a murder had happened there, it was incredibly deprived etc...
It was silent at night, you might get an end of school term party that was quiet before midnight from time to time, but that was it.
The teenaged boys moved out of the way without making any comments if you walked down the pavement, the streets were a bit run down (as in could have done with a fresh coat of paint on things) but they were clean, never saw a police car in years, never burgled.
I left my front door open once with the key hanging in the lock & it was removed, door closed & popped through my letterbox (neighbour came to check was I okay after doing that), parcels left leaning against my front door were still there when I got home hours later, or taken in by neighbours.
It wasn't perfect, but it wasn't even slightly worrying to live there.
Some kids set fire to a bush one time & their parents had a right go at them, so that never happened again.
People were poor, but mostly decent, regular people just minding their own business & getting on with their own lives.
Turned out the murder had been a couple of decades before but the reputation had stuck.
They didn't have posh accents or expensive cars, they didn't take cruises every year or go on 5 star holidays, but they were nicer neighbours than my previously much 'posher' area ever had.
There are a few places in the UK I wouldn't move for any money, but the one I lived on for a few years was meant to be in one of the most deprived areas in the country.
Move with an open mind, you might be surprised.