Most of the problems with dogs are owner related. the vast majority of people who self train dogs do a very poor job of it and the dogs are just not well trained at all.

Most dog "trainers" are not much better at it.

Fortunately, even poorly trained dogs are usually not that much of a nuisance.

I like hiking with my beagle. She loves it out in the woods and just has a grand time. But I do not delude myself into thinking she is an asset anymore than a child is an asset. Both require far more in resources than they are worth most of the time. Yet human beings have traditionally kept both dogs and children for some reason.