I got into games a couple of months ago, before which I had done a few mods (for Age of Empires II, C&C:Red alert 2, etc.).
Some Old Mods
I made most of my old mods for my friends, so they never got released, though some have been (for Age of Empires II), such as "The Fall of Constantinople".
Earlier this year, I made a few multiplayer mods for Soldier of Fortune II: Double Helix. But again, they were just for servers I hosted for my friends, so they weren't released.
Current Mod Project
My current mod project is Golden Horn, which is a modern military first person shooter conversion of the Source engine. This is the first time I'm using the Source engine, but I'll figure it out quick enough. If you want to check it out, see http://developer.valvesoftware.com/wiki/Golden_Horn .
I can model (a bit), code a bit, do 2D graphics, and animate, but I can't really help with any mod until Golden Horn is released. It's development starts in February 08, so that'll be a while... After that, I'm still going to be making stuff for Golden Horn (patches, maps, etc.), but I'll have more free time.
Ambitions with Source
Since the Source engine can be used with the Xbox 360...I obviously want to make an Xbox version of Golden Horn (or something else).