All of us have dealt with those kinds.
1. Overzealous ActionJockeys, who would just do shit - bothered only about local maxima ("I did mine! His thing is not yet done!" or "My code is superb; others' is total poop") Few variants are BrilliantJerk, who is supersmart but nobody wants to work with him. Also on same lines are some appreciation junkies and hero-role-playing characters , who always want to "save the day" - the LastMinuteHero types; but they'll never ever train others to hold their own as that could pose a peril to their heroism.
2. Dr AnalysisParalysis and his gang of bikeshedders. Could spend a week to choose the color of a button and while doing so earn a PhD in color theory.
3. Clueless Jimmy who just does what the leads ask him to do. He's a sure shot follower (in the lead-follow-or-get-outta-way kind) who just does NOT want to know the big picture.
4. Albatross managers. They come, they scream, they poop and fly away. Caw-caw caw Ca-caw!
5. IndifferentManagement - Anything goes as long as money comes in timely.
"All doers, no talkers" is just absolute peak Silicon Valley - may be the does should talk often and properly, to do things well. And do it well.
Collaboration over competition - it's 2020 FFS!
One approach is building a team that actively prohibits bad characters (like those listed above) and empower them by treating them like adults, and things would just work? But very few would do it - cause "the SV prophets said otherwise! "