Yorkies may go overboard with their enthusiasm, but proper training can keep this in check.
Pugs are a tiny bundles of energy, and make good therapy dogs.
There's a reason why Beagles don't make good guard dogs, and that is because of their affectionate and friendly nature.
They excel as therapy dogs, of course.