I also fell into programming and while I like certain aspects of it, I'm not sure that I'll ever be a great programmer. My personality sounds much like yours. In addition, I simply cannot force myself to RTFM -- I typically rely on learning new ideas and tricks by trying out suggestions made by those around me or things I see on PM. It also doesn't help that I work in a java-centric environment -- comments are continually thrown around that Perl programmers aren't 'real' programmers. It's a morale killer at times, however I try to ignore it.

I wish you challenges and joys in your new career move. I hope you find the changes more suitable for your personality!! :)