Meh, my best friend growing up had a cocker spaniel. Whiny little scaredy-cat (or is that scaredy-pup?). Guess it depends.
I generally HATE small dogs. They're higher strung and yappy. However, there are two that I've seen several examples of that have been really sweet and cuddly: Pugs, and daschunds (sp?). Pugs are sprightly, energetic, and affectionate. The daschunds I've met are cuddly and sweet, and enjoy their walks. I think the cutest ones are those with the black bodies and black and white spotted legs. SO CUTE! These guys are pure companion pups. And not yappy, if brought up well.
Plus, if you have big dogs already, the puppies will be socialized by them, thus learn to act more like big dogs in small bodies. Always a plus, and a saving grace for the small and yappy.