Good point, well made. Being a new PPL holder, I'm still at the stage of saying hello to the kids with an orbit or two but I never stay more than a few minutes and never below 1800 agl.
The next door misery is just dying to complain and unfortunately, our village is right on the path from the local training area to the airfield so we do get our fair share. To be fair to the villagers, they don't complain often and only when someone is loitering for ages - typically aerial photographers (you can bet you'll then get the door knockers trying to flog some crap photo).
I think an orbit or two at a safe height is fair enough. 30 minutes at 800' is taking the p*** and just selfish.