Well, "Ze Awesome Cavalry Assault Strike" also was likely not "Ze Awesome 'Dude, Where's My Army?' Cavalry Assault Strike" as well. It would be "Well-Timed Awesome Cavalry Charge That Decides The Battle", no? There's having balls, and then there's just being plain dumb.
Thankfully, the only time I usually see a general waste their life THAT utterly is when the computer has decided that the rest of its army will be entirely impotent and the bodyguard units would be the only ones capable of doing any sort of damage to me. At which point, I usually have a serving of Dead General.
The most usual thing I see is the general wading in with his troops, which greatly enhances his survivability and my consternation, if there is 4 or 5 FM's pulling that little stunt. Though it hasn't hurt me greatly by them doing so, I usually do take far more casualties than I would have otherwise. If I don't get at least 2 of the buggers I am usually disappointed.