I don't find them lame at all. In my KH campaign I've used them as flankers when I could afford it and as front line units when I couldn't. They held the line just fine even against phalanxes. I had to use them on the walls once and the general defended the wall without taking too many casualties. The only time I've lost a general was in some crazy siege when his unit was fighting too much on the streets and got exhausted. You just had a very bad luck in that battle.
I had something similar, only in Medieval TW. I've nearly completely destroyed the enemy with the only thing remaining was the enemy trebouchlet (sp). Having no other cavalry than my glorious general, I charge him there across half the map. Exactly at that time the said trebouchlet fires on one of my 3-rd grade militia units, but it misses and hits my general bodyguard unit who were just riding towards the trebouchlet, result - general killed on the spot.
And if we're talking about crappy generals in EB, that's Roman Consulars. They are nearly useless against anything, except may be skirmishers and already wavering troops.
Bookmarks