There's a misunderstanding here that I seem to get that gaming is all about programming - at least, that's where the topic has led.
Whether it's for fun or not, game design and development requires for example (some people have multiple talents) :-
Modellers
Skinners
Graphic Artists
Level Designers
Sound Designers/Engineers
Programmers
Scripting
Writers
If your doing a project for fun and lets say it's either an open source modern game engine or a TC for a commercial game engine, if you want to at least compete on a fun level with the pro's, you are going to need a team these days. There's no two ways about it.
Even if it's just a team of 2 - programmer/artist.
I've worked on a project called M3A with a bunch of other level designers some time back - it was for Rocket Arena. The project took quite some months to complete and there was no programming involved - we all contributed levels to a pack.
The website is no longer active, but it got good reviews at LVL :-
http://www.planetquake.com/lvl/comments.asp?id=814
Other stuff I've done :-
Arenaholica for Quake3 (DM level)
http://www.3r.co.za/bushboy/arenaholica
Mental Oasis for Quake3 (DM)
http://www.3r.co.za/bushboy/mentaloasis
I've also done a ton of texture work in the past.
Yeah, blowing my own trumpet, but the fact of the matter is, I've been messing with game design (mainly level design and texture work) since 1996 and I've only ever released four maps (altho I've done about 100 textures)
My first site and attempts at learning level design is still online :-
http://www.planetquake.com/qpp/
That was for quake1, sadly, my second site for quake2 I gave for someone else to take over and they messed it up.
As for the future - well, I want to learn how to model - with Doom3 and Half-Life2 coming up, as a level designer, modelling will now be a neccessity. I need to give up my various other hobbies and concentrate on this, as I may make another career move in a few years into game design.
Hang a left by
http://www.doom3world.org - lots of like minded individuals from all over the world interested in all aspects of game development.