I think that part of it comes with internal balance.
(disclosing personal information about myself... this isn't a debate, just sharing the inner person that is Greg)
When I was growing up, I used to "Pendulum" a lot. I was very intellegent, I was actually skipped over 4th grade (MISTAKE! Don't ever let them talk you into this as a parent for your kid....) but, anyway, I was highly intellegent, but had a low self-esteem. I would go back and forth between being an egotistical schmuck, then after getting "slapped down" by my peers, would swing the other way to a complete lack of self-confidence; to the point of being depressed.
I didn't *WANT* to excel in school, because then I was a nerd, brainiac, etc. Then, when I was in my "low" point, teachers and parents would start to build me up, until I went all ego again. It was a nasty cycle, and one that I'm sure I'm not alone in.
People now know that I can do pretty much anything with computers that they need done; but I temper that. I have had so many people say something to me like "I just feel so stupid" (when I'm working on their computer problem). I point out to them that everyone has their own specialty; mine happens to be computers, but I'm lucky to know where gas goes in a car. It always makes them smile a little, and makes me seem more human, and a little less aloof.
That balance isn't easy to reach; you have to be comfortable with your skillset and confident in your knowledge, but also realize that there are other people out there, whether they be doctors, mechanics, crafters, artist, who have an equal amount of intellegence and skill, just in a different area.
One of the mistakes that I see programmers make, especially, is that they are approached to do a project, then they develop what they *think* the users want. Then they roll it out, train, get feedback and complaints, adjust, or worse yet, *mandate* to the users that this is the "best way to do your job."
I am at the point in my job where the end users have come to me, with a rough drawing of a web page, and have said "Hey, if we had a page that looked like this, we could enter this and this and this, and a drop-down of clients here, etc. etc. and that would make our jobs easier!"
The great part about that situation is that the end users are already vested in it; they are looking forward to the product, there's minimal training required, and everyone is happy. A true "win-win" situation.
This scenario, of course, requires me to be approachable. If my door is shut, if I don't pay attention to someone coming into my office, then I am closing down that person. I'm being aloof again.
I heard of a manager who had a popcorn machine in his office. Everyone was encouraged to come in and get a bag of popcorn whenever they wanted it. I didn't quite go *that* far, but I order cases of gumballs, and keep them on my little conference table in my office. *Everyone* comes in and gets a gumball at some point in the day. Sure, a case of gumballs costs me about $40 (850 to a case), but everyone knows that my door is open, and they can come in any time. This has been great, because the conversation goes to anything from "Just popped in for a gumball! Which one is cherry?" to "Hey, working on anything new? Wow, I don't see how you can sit in here and write programs all day..." It's a great way to get folks to drop by. Then I can follow up on things as well, such as "Did you get your e-mail working OK?"
The majority of the people don't really know what I do; they don't realize that I monitor the backups, that I make sure the servers keep running (since we have redundant drives, power supplies, etc. any "outage" we have is usually totally transparent to the end users), fix PC's, keep inventory, and program. The switch from Access to SQL server went nearly invisibly to most users, other than them commenting "Boy, things seem faster for some reason..."
Find balance. Remember to ask questions; it empowers people when you say "How can I make your job easier? How can I reduce your paperwork?" It not only gives them the opportunity to explain their job to you (which puts a deposit in their emotional bank account), it gives you a better idea of how to streamline their process in a way that doesn't seem "mandated by the computer guy".
Just my 2¢
-Cole's Law: Shredded cabbage
--Greg