Considering myself an above average guitar player - I'm not sure whether guitarist vs drummer abilities carry over to hacker vs business skills. Your problem with playing the guitar was most probably related to left-right-coordination or some physical feature (like joint flexibility), right? Or maybe you did not "hear" the notes?
I think that both good/x10 business people and hackers need similar personality traits (or let's call them habits) - focus, persistence, and willingness to learn. Concrete skills like talking to or with people you have never seen before, or learning a framework in the matter of days, can likely be acquired when trying long and hard enough. E.g. I learned to learn new songs in the matter of half an hour or less; I'd never imagined I was capable of that! But it's a skill just like any other.
But we really have to _want_ to get good at something in order to do it. Staying with the guitar example - I can do finger exercises for months and months, but if I don't have a lick I want to eventually be able to play, I will not follow through, whatever focus and persistence I put in during exercise.
That's why I prefer to sketch out interfaces before implementing them - hacking and Photoshopping is just a necessity in order to get the product I dreamt up. I do enjoy programming, and I do it focussed and persistent, but I have to really want the outcome (in that case a cool interface and UX).