Yes, definitely. The trick is to choose materials that are designed for weather but haven't sacrificed design. Powder-coated aluminum is probably the most city-friendly option: it won't rust, it's light enough to move around a balcony, and it comes in sleek colors like charcoal, sand, and deep green. Pair it with quick-dry cushions in performance fabric, and it looks more like a boutique hotel terrace than a rainy sidewalk.
Teak is another classic. It ages into a silver-gray patina, which looks great in urban courtyards, and it can handle rain and sun if you oil it once or twice a year. For a tougher, low-maintenance look, HDPE lumber or recycled plastic is worth considering. Modern brands now make it in clean silhouettes rather than the old picnic-table style. All-weather wicker over aluminum frames also works well; just make sure it's UV-resistant and not cheap resin that fades.
Concrete and fiberstone are very urban and stylish, especially for planters, coffee tables, and sturdy benches. They're heavy, so they're better for roof decks or ground-level patios than a small balcony. Stainless steel is sleek and weatherproof, but in coastal cities you need marine-grade 316. Also think about drainage, covers, and storage. Even weatherproof furniture lasts longer if you can tuck cushions away during storms.
Style-wise, I'd keep the palette simple: black, warm gray, teak, or olive, then add weather-resistant textiles and a few plants. Modular seating, slim lounge chairs, and nesting tables make small city spaces feel intentional instead of cluttered. So yes, you can absolutely have weatherproof urban outdoor furniture that looks stylish. You just need to mix the right materials with a clean design and a little seasonal care.