I'd love to have another Basset Hound one day. They're wonderful. And I don't think they qualify as a "little dog".
Bassetts are cute because they look like cartoons. None of the proportions are right.
Doxies I don't have a good experience with :~0 Yet...
But Scotties... I like. They aren't a good dog, they're a riot.
I've known a couple of mini schnauzers. Major personality...though the two were very different.
Dachshunds are entertaining but insane. At least, that's how the five or so I've known now have been. I dunno that I'd want to have 'em again.
Personally, though, I'd say Lab/Border Collie mixes are just about perfect. Not that I'm biased or anything.
Dalbradors are awfully nifty too. ;-)