The worst ones so far are the Housecarls Lydia (Whiterun) and Jordis (Solitude).
Lydia must hate sneaking. Sneaking into a cave battle against a large unmber of enemies with Lydia is like using a megaphone to annouce your arrival & passing out maps of your location to the enemy just before you attack.
I'll be sneaking into a cave ready to shoot arrows to cut the numbers down before the enemy knows I'm there and where I am and before I can get the first shot off, Lydia goes streaking past me with sword held high yelling "I'll kill you all". All I can say then is ;- "Thanks Lydia, I always wanted to die".
Once the battle is on, she'll be fighting one enemy & I'll see another coming so I lineup a good shot and the instant I fire, Ldyia breaks off from her fight and jumps in front of me, taking the arrow for my enemy.
Ldyia has died numerous times and always from MY arrows or sword because she ALWAYS jumps in my way just as I swing or fire.
She always says "I've got your back" but she doesn't seemed to have realized yet that a person's eyes aren't in the back of their head.
Also, I always put my horse some place safe before approaching an enterance then start sneaking. Where is Lydia? 5 feet behind me sitting tall in MY saddle on MY horse getting it filled full of arrows. IDIOT!!
Jordis isn't much better except that when I go to my horse she races me & gets on first. When I make her get off and I get on, half the time she hops on again right hehind me so the horse won't move.
Uthgerd may have been a good bar brawler but she gets killed within the first 2 or 3 minutes of every fight. She's worthless
Benor may have a big ax and a powerful swing but his 2 handed ax is so slow that every third enemy kills him.
Faendal is good. He doesn't get in the way, too, often and he's a good archery trainer.
Jenassa the elf is good. She hardly ever gets in my way and then seemingly by accident while in battle. She uses 2 swords and spins them like propellers and hasn't even come close to dying yet. She never bothers my horse and when I sneak, she sneaks.
So far, she's the winner by far with Faendal a close second.