Gabe Newell said recently:

The programmers of tomorrow are the wizards of the future. You’re going to look like you have magic powers compared to everybody else.

That statement is very true, but there's a flip-side as well. When you have a reputation as a "wizard," people who are not "wizards" develop unrealistic expectations of you. This can include your boss at work. The most frustrating thing is disabusing people of the notion that you're actually not a wizard, that there are limits to your knowledge base, and what can be physically accomplished using the tools available, within the time constraints, and trying to explain what those constraints are to those who have never programmed a computer before, and don't want to. More often than not, I just have to go into either "management speak," or find some way to lower expectations with social cues. I can't explain to them why I can do some things well, and quickly, and why I cannot do other things at all, or I can do them, but they take a long time. This is where having a trust relationship is crucial. If you don't have that, then you're just going to be banging your head against a wall.