Minecraft, only because there's almost every mod ever for it. But aside from that, GTAIV and V looks like it'll have some amazing mods soon
1. Skyrim 2. GTA IV 3. Star Wars Jedi Academy Mods make these games so much more complete, immersive and fun.
Some of you misunderstood the topic, it's about games that begun as mods and became "real" games, like Counter-Strike or Dota, not about which games have the best mods.
Yep, Counter-Strike for me. Holyshit, it's probably the best multiplayer game I've played. I miss the days of staying up till 6am with my mates playing minigames on it.
Sven Coop. The best online cooperative ever done so far. It will come stand-alone for free this year in Steam, i think.
Day of Defeat. Sadly when it became a retail game it got worse. Valve bought it basicly to hire it's devs.
I'm gonna go outside the box on this one: Ms Pac-Man. Started out as a Pac-Man conversion before being bought by Midway, and it's better in most every way than the original.
I used to love dod_caen, dod_thunder and dod_ramelle. DoD Source is such a wasted opportunity. If it had the original DoD gameplay and ambient sounds, it would be amazing to this day.
To be honest, even though I love (good) mods for PC games, I can't name many that became commercial, since most commercial mods are multiplayer, and I'm not a big fan of multiplayer (except splitscreen, or against bots). I know that there was a cowboy-ish science fiction single player mod for Half-Life that was set in space and had dinosaurs (seriously, cowboys + space-craft +aliens +dinosaurs + a vicious computer all in one game!) and it was OK, but lacked replayability. It's called Gunman Chronicles (which I remembered from the list, below). There are some superb mods (such as Half-Life's They Hunger Trilogy, USS Darkstar, and Azure Sheep (Azure Sheep might well be even better than the original Half-Life, in my opinion), Deus Ex's Shifter, GMDX, The Mod with No Name, etc, Unreal Torunament 99's (still my favourite UT game) has Weapon Factory Arena, Unreal Fortress, Soul Harvest, etc, plus some fantastic maps (such as the ones from Goldeneye, which to a GE fan like me is wonderful), plus hundreds of other mods, from the very small to near total comversions for many games such as Grand Theft Auto 3 onwards, Skyrim (I've not yet played Morrowind or Oblivion), Doom, etc. But none of them ever became commercial. I couldn't find a comprehensive list of mods that became commercial games, and the best I could find was this (from http://www.mobygames.com/game-group/commercial-mods), which surely doesn't list them all. The Stanley Parable DayZ Dear Esther Chivalry: Medieval Warfare Dino D-Day Nuclear Dawn The Ball Killing Floor Half-Life: Before Awakening Garry's Mod The Ship Red Orchestra: Ostfront 41-45 Day of Defeat Tactical Ops: Half-Life: Counter-Strike 2000 Gunman Chronicles Team Fortress Classic NAM 1998 Malice: 23rd Century Ultra conversion for Quake X-Men: The Ravages of Apocalypse I've not played many of these, and the few I have played were not (to me) good/involving enough for me to name them as favourites of mine in an y sense. Half-Life: Opposing Force was very, very good, but as far as I know, it was never a mod, but always a commercial expansion pack, so doesn't count here. By the way, off topic I know, but I really hate the way modding is becoming less and less possible, which started about a decade back. Bioshock, Timeshift, Singularity, etc, all could have had excellent mods, but sadly not since the modding tools were never released to the public.
I guess you could include Black Mesa. That game was originally a Source mod, and now has its own separate release on Steam. It's a really good game I think, and a very good recreation of the original Half Life. It's not finished though, unfortunately. It lacks Xen, but they've said that they're going to release Xen eventually. I was rather disappointed that they released it on Steam without including Xen, but I guess we already knew that was going to happen. I'll gladly buy it once they release Xen.
I hate Xen - whenever I play Half-Life, I always stop at Xen, since it (to me) stops being fun at that point. It is imaginitively done in the way it portrays an alien universe, but I find it no fun to play, so Black Mesa's lack of Xen doesn't bother me. I did complete HL including Xen, I have to add, but never again. I think Half-Life 2: Episode 1 was the first official HL game to have a good end battle, and HL2: Ep 2 had a really fantastic ending battle.