In our first house together, we didn't have any issues with our neighbours. The bloke was really nice, would always say 'hello' and let us borrow his hedge strimmer. The woman would just ignore us, but no arguments.
In our second house, both sets of neighbours were fine. We never really spoke to them except to exchange deliveries, and when the neighbour accidentally ran into our car (which was sorted very amicably and they were massively apologetic).
In our current house, the one side are really nice, and next door but two are really nice. The other side is council owned, and the tenant when we moved in was... interesting. She had a range of gentlemen callers at all hours of the day, and sometimes conducted spirited conversations in the street with them, often at 2am. Such as:
HER: You're not coming in, I've got kids and you're a f*****g crack head
HIM: What did you f*****g say? **** YOU!
HIM: Give me my stuff! Give my my stuff, you f*****g w***e, or I'll slit your f*****g throat
One of their gentlemen friends also referred to Benny as "a stupid f*****g dog". Which to be fair, isn't an entirely inaccurate statement, but a bit harsh. All he did was bark once in surprise because the guy smacked into the fence loudly.
Anyhoo, one lunchtime t'husband returned home to check on the dog... and they were gone. Their house had metal grates over every single one of the windows, and security doors installed over the existing ones. It was a bit like that bit in Dredd when the security measures are activated on the tower block.
A few weeks later, she was allowed back in to collect her things. A week after that, the council went in and got out her left over rubbish, two skips' worth.
A new tenant moved in. Again, she doesn't seem overly fond of us but we're not sure why - we've tried saying hello, but she blanks us. :s Her friends are all really nice though, and she takes good care of the garden, and has three spaniels, so she's OK by me.