There's many aspects to game development. From concept creation to the graphic artists designing the boxes they will be shipped, and everyone involved in between. To those that say they're not any good at programming; I think its more along the lines of its just not an area your choosing to develop (not that you don't have the ability to)
Its common for programmers not to be very creative, (or in terms that most understand is creative- programming is creation) but brilliant at coding- and vice versa. Also within the animantion (majority 3D Studio for games) the process is broken down in teams for animation- lighting, object creations, backgrounds, rendering, etc almost like an asembly line. Alot of creation comes from the writing of authors who will only use a PC for writing out the games plot and story board in word.
There are more and more degrees that schools are offering that will help pave the way of your goals.
http://www.uat.edu/multimedia/gamedesign/
Sorry if this sounded like a commerical, I'm a student there myself for interactive media and digital video production- they all fall under the degree of multimedia.