1. Hardass who pushes everyone to the limit, tends to micro-manage, frequently overrules consensus with his own views.
2. Total pushover who agrees with everything. Constantly seeks consensus and rule by democracy, never pushes anyone and just tries to be everyone's friend.
3. Somewhere in between the two above. Seeks consensus and lets people make mistakes in order to help them learn. Sometimes overrules people in order to make sure things don't get too far off track. Doesn't try to be people's friend, but is sensitive to people's needs and gives a reasonable amount of leeway.
The somewhat counter-intuitive thing is that #2 is by far and away the worst kind of boss to have. It's fun for about a month, and then everything falls apart. The teams never seems to get anything done. All the best people eventually leave because there is never any consequence to incompetence and so tons of people just default to being lazy (think: working in government.)
Although #1 is tough and often unpleasant, he tends to get things done (albeit with higher turnover and more grumbling) and most often at least ensures that the company succeeds (think guys like Steve Jobs and Bill Gates, who are notorious for being insanely demanding and insensitive.)
Lastly, it's insanely hard to hit the right balance between #1 and #2. Really it's damn near impossible and requires some kind of magic innate talent to be able to inspire and push people to work hard without crushing their spirits.