I've been a SWLer for years and am considering getting a ham license.
However, I live in an urban area (Brooklyn) and wonder just how
effectively I can transmit from here. Big outdoor antennas and ground
radials are out of the question.

Obviously I'd be starting out on VHF and UHF frequencies, perhaps with
only a modest handheld transceiver. Handhelds look pretty puny, but is
this appearance deceptive? Would one allow me to talk to lots of
people and learn from them?

Any insights you can share will be greatly appreciated.

Steve