I have a half Aussie, half Chow that is dumb, dumb, dumb. Love him to death, but he kills skunks and then brings them up to the house with his tail wagging and eyes bloodshot and tearing. He still hasn’t figured out that the squirrels live in trees. He will chase them to the tree and can’t figure out where they went.
I would say this list is pretty accurate for dog at least.
I owned a German Wirehair a few years back. Not dumb, but didn’t give two hoots what I was up to. Aloof is an understatement. Worse than a cat.