I love dogs, grew up with various sizes (grandparents had a giant breed when I was born) & owned through adulthood. Now have a small(ish) breed that thinks it might be one of my cats.
Most dog behaviour relates to training & treatment, but we need to realise that there are genetic traits related to the job that the breed was originally designed for. I know people who have huskies as family pets and have managed it perfectly. I also know someone who has XL Bullies and they behave impeccably because they are trained and exercised. They live with a chihuahua who is definitely the leader of the pack. I also had a friend in childhood that had a Staffy and a Jack Russell Cross. The staffy was the softest, daftest dog ever born. The JRT was just mean!
It's about being sensible though. If you don't have the time or patience, don't have a dog. Have a cat, they ignore you most of the time and come for fuss and food. If you have kids, look for a breed with patience that isn't likely to be highly strung. Whilst smaller dogs can still bite and cause damage, the consequences are likely to be less devastating than with a dog that is stronger (& sometimes bigger than the owner).
I do believe in licensing for dogs and compulsory minimum level PL insurance. The law already requires micro-chipping but I suspect that this is often circumvented.