The 90s were worse from what I remember. Housing improved for a while and things generally got better, but after a decade of austerity I think we're heading back there.
The council is skint and your description of "it's filthy and nothing works" is bang on.