I can do some devastating charges even with celtic light cavalry. I think think the secrets are:
Do not charge an infantry unit if the unit is not already engaged.
Wait for them to get tired before charging.
Charge units with lower morale.
Rinse and repeat.
I believe that bad timed charges are less effective in RS2 because of units armour and mass.