Because he refused to sugar-coat the truth to make it more palpatable to the masses. Can he be abrupt? Yes. Can he be condescending? Yes. Is he usually right (although, not always)? Yes, again. I voted for him in the primary and I'd do it again. While I don't agree with him 100%, at least he seems to understand that to compromise means to give up something that you'd rather keep. IMHO
You are so correct. Unfortunately to many in our country today, being "charming" is more important in a candidate than their stand on the issues or their adherance to principle.
I also voted for him in the primaries, because logic demands one vote on issues, and not personalities.
The real reason he's not POTUS is because his views are (sadly) way out of step with the average American voter.