Saddletank
You are quite correct that the Cavalry is "fickle". This is why I advise all that the best thing to do is always TC the Cavalry. Yes I understand that this means "micro-managing"; but in the end the results can be much of a gain.
But, just as with Infantry units, you should always "look at what you have". What are the units attributes? And, are they "regular Cavalry" or "mounted Infantry"?
Yes, with the invention of the more accurate rifle, Cavalry played a lesser role in actual assault charges during the ACW. But if you know how to use Cavalry.....the "what if's" are countless for this Sim.
Seasoned, Regular and Veteran units are best for melee/fire fights (some Volunteer units as well....they may not be much for melee; but they might be good marksmen). Conscript, Irregulars and Militia are best for scouting and capture of supply trains.
Also, what type of firearm are they equipped with? As we know, Carbine equipped units can have a devastating effect on enemy Infantry (and enemy Cavalry) because of the faster loading/rate of fire. Units armed with Enfields/Springfields can be highly effective for flanking.
But you must pay strict attention to their marksmanship. The "average" unit will not be as deadly as those with "good" or above.
I recommend Saddletank (and all of you wanting to understand and learn more about the effective use of Cavalry) to do a web search on the Tactics and Strategies of Genghis Khan.... The finest Cavalry strategist. His use of "deception" manoeuvre's were the most brilliant and deadly of any I have ever researched.
I hope some of this helps..... but more questions are very welcomed.
kindest regards
The Mad One