In your next family gathering people will ask you to fix their computer. You say 'Sorry I'm not IT, I'm a programmer'. Suddenly they dislike you. Do they dislike your cousin who waits tables for not fixing their computer? No, just you.
Similar themes play out in a business setting. If you're competent everyone will want you to do everything important. Which will result in:
1. You get stretched too thin and start making mistakes -> fired.
2. You refuse to take more than your share of work. This is seen as a slight to whomever you refuse. Similar to the above anecdote.
No one gets upset with the person who can't help them. They get upset when the person who can help them doesn't. Additionally people tend to focus on what you haven't done yet, not what you've already accomplished. The more that you are able to do, the larger the unfulfilled expectations become. Suddenly a large portion of the projects are complaining that they would be further 'if only we could get Redmaverick to help'. Now you're seen as the bottleneck for not helping, rather than the asset because your skills apply in so many areas.
If you are a skilled person who can execute tasks, it is vital that you always frame yourself by your accomplishments. By default your capabilities will be used to create a long string of perceived obligations.