i grew up with great danes and due to that worked predominantly with large and giant breed dogs while volunteering at a shelter. i was part of a group who trained dogs in basic obedience before they were adopted out, which increased their chances of finding a new home.
after my first own dog died, i was "dogless" for a while and mulled over a short list of large breeds for my next pick. it didn't come to that, since about 6 months later i found an abandoned 8 week old wirehaired dachshund and kept her. she was tiny as a puppy and topped out at 20 pounds as an adult - about 1/5 of the size of the dogs i was used to.
had anyone asked me if i ever wanted a small dog before i got her, i would have laughed in their face. now i know better. she was from german working lines and had a terrific personality but despite her high drive she was well behaved.
all i can say is look for the proper temperament that you want in a dog and socialize and train it properly. a small dog doesn't have to be a neurotic, nervous, yapping annoyance just like not every large breed is automatically mellow, stable and quiet.
make a list of what you expect from a dog and what you want to do with your life. don't just pick a breed for looks.
when i was looking for a new dog 4 years ago, i had completely different requirements from my previous dogs. i used to live in fairly rural areas of germany, with few restrictions on where you could take your dog, exercise off leash and so on.
now i live in L.A. and own a house, but my back yard is fairly small so i find it unfair to have a dog who is too large to feel comfortable. i also own 5 cats, so a dog who wouldn't be able to coexist with them peacefully is out of the question. in my free time i like to go camping and on road trips, another area where size is important - i want the dog to be able to travel in the car comfortably and many hotels and motels only allow dogs of around 25 pounds or smaller.
the dog i ended up adopting fits all my requirements to a T and he topped out at 30 pounds. even tho going strictly by taste i prefer large dogs, he is perfect for my current situation.
as i have gotten involved with different breeds of different sizes in the past 25 years, i can appreciate them all for their different traits and personalities. my "list of breeds i'd like to own at some point" ranges from small (i'm a huge terrier fan, especially jack russell, border and german hunting terrier) to giant (giant schnauzer, black russian terrier, irish wolfhound, mastiff), but my first determination will always be what kind of living condition i can offer them and how fair it is to the dog.
last but not least, keep in mind that the larger the dog, the more you will automatically pay for everything: food, care, veterinary costs etc.