actually, hoplite type (without phalanx mod, or any mod that take their +4 attack value) is the most effective troops to be used on stone wall (not large), as my current KH campaign against Romani.... they could take down even pedites extraordinarii out of the city wall...
Spoiler Alert, click show to read: 
but most of them die falling... in large wall, they're not as effeective