Seeing as I'm not that good a Commander with missile units(they usually just get run down)I rarely use them,However they are brilliant for running ahead of an advancing army,when they are not too many enemy units about,to weaken units before the main shock troops hit home for easy routing.
I can see why people get hooked on them but give me archers/heavy infantry/light cavalry combination any day