I live in SH.
My street is ex SH, most bought with about 10 still SH. I am in a terrace of 4, in the middle.
My neighbours love me as prior to me they had neighbours from hell, drug dealing, DV, late night parties, culminating in police raids and eviction by force (again, police involved with doors smashed in).
2 doors up, private house, their sons where a nightmare, boy racers and late night parties, fights, awful basically, I called the police several times but it made no difference. Only stopped when they left home and their parents let the house to a gorgeous family, thank god!
So, you could get a neighbour like that OR, more likely, a normal, working, family, just like mine!
Agree that theres more you can do wrt complaining with a SH tenant, than with private.
I love my house and my street. The HA keep it lovely round here.