The team member who works tirelessly, is over-committed and has super hero work ethic is probably also judgmental, highly self-critical and not at peace with herself.
The manager who's bold and courageous and is great at launching new projects, most likely doesn't think things through and has a tendency to leave people in his dust.
Talents are patterns of thought. Patterns in and of themselves are neutral. They get judged good or bad based on the situation in which they are presented.
Rather than thinking of your team members in terms of their effectiveness, figure out their patterns. Then choose the best pattern for the challenge you're facing now.