I agree with you about artillery, I've never got a result from them yet that makes them more valuable than other units. Even when I'm attacking and the enemy just sit there I get better results from misile.
Can anyone explain where I'm missing the point with artillery? I want to use it, but it causes bugger all casualties. So I stick to bows/xbows to cause casualties, and they can fight melee too.