There's also the case of the passionate but incompetent. I'm not sure if this is what you're talking about, but I can think of one person I worked with who had the best of intentions and was highly motivated but was just utterly, hopelessly incompetent.
Passion is a double edged sword. I've known people who were passionate and misguided. Their passion to propagate their misguided viewpoint was a drain on the team and caused much drama.