""few people have reported them to the council, who have done exactly zilch about it. So I'm afraid OP my experience is a negative one.""
In reality, your negative experience is because of the Council.
Thee HA houses that are let on new build estates are only let to working people, with checkable background conduct, or those on higher rate disability benefits, in my region.
My Housing Officer gets right onto fly tipping, front garden mess etc. I'm in a 'disadvantaged' hard to let area of Liverpool. The primary schools aren't good and there's a lot of drug selling, but apart from the odd police raid/shooting, it doesn't impact on the area.
In terms of bad neighbours, I've had a better experience here than when I owned my own home, in a 'better' privately owned area.
We had a Student let, which was a nightmare and just as Evironmental Health were acting, the Students would leave, or be away over summer, so it went on for years. Likewise a 'partyhead' but in a respectable job, situation, in a nearby street.
My HA would have acted fast in both issues.
It's the management of the rented houses that let down the other residents, the local MP is one route.
IMO, though a lack of money is what is causing a lot of the fly tipping that happens. My HA used to put skips a few times a year in the neighbourhood and they used to get filled, but they no-longer have the budget.
The issues that we have with dog dirt, happens across the City, that and the amount of littering is my personal bugbear.