Archers/crossbows are the primary unit to weaken other units, while siege units are built to attack cities. This is why archers have a vs-city penalty, and siege a vs-unit penalty. If you build a mix of archers and siege you can handle any ranged battle. There's more details about this in the
combat roles thread.
The G&K expansion will have late game ranged units.