The example that immediately springs to mind, in the tech industry, is the "Steve Jobs Asshole" archetype.
Steve Jobs was a notorious manager, in that he made heavy-duty demands, did not suffer fools, and was blunt to the point of abusive.
But he was also able to filter for talent, cultivate it, and encourage excellence. He wasn't just an asshole. He was really smart, driven, and impatient with things that got in his way.
I have worked with two people, in my time, who worked directly with him at one time, or another, and they both hated him, but I have also worked with a number of folks like Steve Jobs, and have learned how to navigate them. It isn't pleasant, but it's generally worth it, to get on their good side.
Unfortunately, a lot of not-so-smart, and not-so-creative people have picked up on the "demanding asshole" part, without the "smart, selective, and creative" part, so they are just assholes. They honestly believe they are channeling Steve, but they don't get the same results (for the record, Steve Jobs had a lot more failures than successes, but his successes were off the charts).