All dogs are great. Please don't pass up rescue dogs. Many shelters/pounds have all sorts of rescues. I love border collies, and while I had my big border collie, my wife wanted a little dog, so we adopted a rescue from a shelter. He was 5.5 pounds, and very emaciated. 8 years later, he weighs 9,5 pounds, and since old age took my border collie, he has bonded to me something fierce. In all fairness, I have bonded to him too. when I go shooting, my wife says he watches the front door, and garage door to see if it is me. If it sounds like a car is coming into the drive way ,he gets all worked up. He is very happy when the three of us are all back together (wife, dog, me).
Rescues will usually surprise you by their loyalty and affection. Take your son to a shelter, and see if he hits it off with one of the dogs.