I'm going to push back a bit on this. People like Spock and Sherlock only because they are incredibly capable. That is, it's entirely predicated on their instrumental value, not because of their personality. If they weren't as capable, people wouldn't hesitate to kick them to the curb and never interact with them.