I have worked both with micro-managers and macro-managers. And I have taken notes on both the strengths and weaknesses. To summarize, my experience working with a micro-manager is tainted with character-building and sharpening of my stoicism. I am grateful for the experience, but will certainly not repeat.
My experience working with a macro-manager is colored by a quest for meaning and purpose. Both extremes are not ideal, but if I had to choose, I would prefer the later, one where trust is given. One where by sharing ownership, a person slowly grows genuine interest and —dare I say— passion. And by claiming ownership, the person becomes invested in it, takes responsibility, and becomes more productive —because they are ultimately enjoying the work. This form of work, where the manager surrenders management, effectively brings about the best of the person, all the while completely delegating the work. It is genius.