I'm surprised no one mentioned the #1 use for missile units yet; clearing an enemy town square. Archers are handy in this situation, thanks to their ability to shoot overhead, or rather over the buildings.