In the umpteen years I've been in IT I come to the conclusion that most of the time management did not add a lot of value to my job as a programmer. I even dare to say that most of them lacked vision, enthousiasm and a sense of direction. All but one.
One manager I worked for had a vision and knew how to motivate a team. We bypassed all protocol and secretly developed a system which he thought was lacking in our company. We took a chance (and we could have all lost our jobs) but in the end it worked out nicely for all of us. The tool we created (in a couple of months time) was well received and we got years of funding to improve the system. Nobody even mentioned the fact that we wasted a lot of company resources and took a big risk.
That would be the most exiting programming gig for me. What's yours?