These are what we call the 'YMMV items.' Things that some people find in this work. We call them 'your mileage might vary' because not everyone sees these things in the same way. This starts discussions in the trope lists, a thing we don't want. Please use the discussion page if you'd like to discuss any of these items.
Inspector Lestrade for almost the same reason. However, much less than Watson and much more underrated. Ergo, the only few fanart of him in existence is somewhere in Rule34.
Moe: Arguably, Smiley due to being in contrast with the usually strong ,neutral-colored and/or beefy male dogs running around in the show. Something about his face makes him look like he's stuck in Puppy-Dog Eyes mode.