Two obvious counter-examples: Steve Jobs and Linus Torvalds.
10x programmer who says what he thinks, gives brutally honest feedback, doesn't couch his facts behind euphemisms or nice-guy behavior, and has extremely high standards for code quality? To many people, this description fits Linus to a T.
And even if you dispute the characterization of Linus as a jerk, Steve Jobs certainly was. I don't see how anyone can hear stories about the way he treats his colleagues and employees, and not admit that he's a jerk.
Did Linus and Steve cost their respective organizations/missions more than they contributed?
I think a more balanced answer to the value of jerks is... it depends. Some brilliant jerks, if put in senior enough roles and given sufficient influence, can produce outstanding work-product. Outstanding enough to justify the loss of morale and attrition all around them. But if you're going to hire a jerk and expect him to be another cog in the machine, he's much more likely to gum up the works instead.
Some roles require rare and outstanding talent above all else. And other roles require someone who can follow orders, work well with others, and not rock the boat too much. Whether or not you should hire a brilliant jerk, really depends on which type of role you're hiring for.