i would add that managers are coaches, not players, in that their work output is generally not meant to produce product (in the larger sense of work product, not just the company's offering) but rather make the producers themselves better.

so one easy way to be (viewed as) a bad manager is to forget that your focus should be people, not product. it is absolutely your job as a manager to ask about and know the motivations and constraints of those you manage, including probing no's like that.