Can one be a leader, and still be a nice guy?

Leaders are usually portrayed as not the most personable people. This seems to be so with many “natural leaders” as well.

But what happens when a friendly and cheerful worker bee is put in a leadership position? Wouldn’t it make more sense for people to want a nice leader? That doesn’t seem to be the case, as you can go anywhere and hear someone discussing the level of douche their boss possesses.