She has urinated/defecated in the house maybe 10 times in the 5 years we've had her and most of those were in the first 12 months. She requires very little walking and is very housebroken. Worst thing that happens these days is a couple of times a year she pukes in the house, but even then we have her trained to puke in our walk in shower.
She also will just lay in our yard when other people/dogs walk by, so long as they do not enter our yard. She will not bark or enter guard dog mode until the lights are off and we're in bed. After that she will guard the front door and only bark if someone is in our yard. She is great with kids and other dogs. Only thing she is not great with is cats. She's also a herding dog (bouvier des flanders) and will reliably have my mom's chickens herded within 1 minute of arriving at my parents' place.
I'm pretty sure we won the dog lottery with her. I understand you're just generalizing, but let it be known that it's possible for some dogs to just be awesome. I think breed has a lot to do with it.