If your team is crap (disorganised and unfocused) you might need that kind of manager to ensure basic hygiene practices are followed. A nice guy who lets people run wild can be just as stressful.

The problem is, most managers never change their style to fit the challenges they face. Headkickers try to whip good teams into shape (and just piss everyone off). Hands-off managers will let an unfocused team drive into an iceberg. If the manager is a bad fit for the team, or you are a bad fit for the team, then change teams.