Advice request from people with small dogs

I've been looking at adopting a dog for a while, and for the longest time I was dead set on a Coonhound/Foxhound and considered any dog under 30 lbs to essentially be a cat for effeminate men and a purse accessory for women. But honestly the more research I did the more I realized that all my hang ups of getting a dog are related to big dogs and the breed I really wanted (baying, being able to grab potentially dangerous things on the counter/in my cabinets, food costs, dog walkers, bad recall training etc).

While I was thinking about this I came across and realized how misguided I was. That little guy is freaking cute as heck. I don't want one that small, but it warmed me up to the idea.

Anyway, look at this cute dog and tell me what disadvantages you've come across having a smaller dog compared to like a 40-60 lb dog. She's a 1 y/o Min Pin mix and 20 lbs but she's so cute 🥰.