hi this is a very good question and it is one that I beat myself up over all the time! I too am from a programming background (Computer Science) and i am now doing a Masters Degree in computer animation which has a large Maya element to it.
I always worry about whether or not my art is good enough, however as one of my lecturers said to me (Albeit a technically minded one (he writes renderman comatible renderers for a living for gods sake!! )) Don't try and be what you're not. E.g. if you're not a artist then don't try and take on the people that are. There are so many aspects of computer graphics for the technical people to excel in e.g. MEL scripting in maya.
If you want to learn a technical / programming based modelling tool I suggest Houdini. It is all based around expressions and programming your own nodes. You dont even have to drag vertices around or do anything visually. You can do it all through setting paramtres etc. You can get some amazing effects! e.g. the fireworks scene at the beginning of LOTR: Fellowship of the ring was done in Houdini. Also I think the glow effects on the Vampires in Blade 2 was also done in Houdini (but don't quote me on that!). You can download a personal learning edition for free from https://www.sidefx.com/
So IMHO don't worry about trying to be all artistic leave it to the people who are really good at it. Use your strengths and see what happens. Don't get me wrong, I'm not saying don't try maya, it's a great program that can be very rewarding but dont rush out and buy it before you think carefully about what it can offer you. I'm in the lucky position of my uni having both Maya and Houdini for me to use (And some bad ass machines to run them on! )
I hope this has been of some help.
Alan
Technical Director - Framestore
Currently working on: Your Highness
IMDB