alt Hacker NewsThere are far more than two types; all of the most effective programmers I've ever worked with can do everything you mentioned and write professionally.
If we have to boil it down to two types, however, I'd split it as "people who think they can do everything themselves and only the code matters" and "people who build effective teams capable of far more than themselves solo", and it's the second group that does the most impressive things. Being professional and respectful is quite beneficial for that group.
Replies
I would say that a swearword where a swearword is due is actually effective and professional. Dancing around an issue and trying to be polite wastes time and effort, a well-placed swearword directs eyes, ears and effort to where they need to be.
It's great that you can do/lead and write professionally. But, in any case, writing professionally shouldn't take priority over doing/leading.
Otherwise we wouldn't have the Linux kernel; and I bet the swearing guy behind it got more stuff done and made a bigger difference than the combination of the most effective programmers you have ever met.