The best, most successful managers in the modern era are those who can keep a player happy even if he is not in the team. Given the size of the squads and the use of rotation nowadays, that's tougher than it's ever been. ↗
I've worked with some incredibly difficult directors but my understanding is that a lot of the best people are driven from a place of being extremely challenging and dark within their way. ↗