I've seen type #1 managers alienate top notch developers due to a lack of being able take constructive criticism, and in general not knowing jack about software development. I've seen fantastic people who were canned due to minor technical disagreements with management while poor performers were left around to cause damage in addition to poisoning moral. I've seen people get the "we expect you to be doing X, Y, and Z at your level, none of which you are" talk, and when they those folks leave, everything falls apart, because either the expectations were bogus, or it really was a personal issue with the boss and the person in question. I've seen junior developers (with talent and potential) languish because they were given zero guidance, yet expected to perform at the level of a senior dev by a type #1 manager without any expectations being presented.
I really don't think you can group managers into these two distinct camps. Maybe you need to have an axis or two extra for rating things like technical competence and interpersonal skills...