I've lived in apartments with my big (55-70 lb) dogs for 13 years now. No problems at all. They have both been fit, healthy, and trim all their lives.
Yes, it's a hassle to leash up in the middle of the night (or in the freezing cold or the pouring rain or the blazing sun) to walk the dog, but the frequent walks are good for them (and me).
And yes, it's tough sometimes to manage leash-reactivity around other dogs, especially if the complex has lots of dogs. The dog owners in my complex just tend to give each other lots of space when we're out with our dogs.
I don't say that EVERY dog would do well in an apartment. I think temperament and energy level has a lot to do with it. I've had low-key dogs -- yes, it's possible for Siberian Huskies to be low-key! -- so the small size of the apartment has not been an issue. We do dog parks and dog training and walking for exercise and to blow off steam, and my current boy loves to play fetch inside the apartment with a tennis ball or his plushie toys.
I'd say the qualities for a good apartment dog are:
- medium to low energy
- ability to calm down quickly
- quiet - not barky
- no fear or suspicion of people
- no strong guarding instincts
- no destructive behaviors (e.g., chewing the walls, ripping up carpet, inside marking)
Those characteristics play more of a determining role than size or breed.
My other suggestion is that you try to live on the ground floor, if possible, and if that's not possible, introduce yourself to the neighbors who live below you. Be open with them about your dog's playtime -- my dog is rambunctious when I first come home from work, of course -- and let them know that they are welcome to tell you if/when you are being too loud.