I'll just link to some of the more notable single player ones, as muti-player mods tend to change all the time. I can't post a few of these at Moddb due to the 2000 character limit.
Most of them are me just nagging people to play Source mods or tell them to avoid crappy ones, so moddb users are not missing much anyways. I also won't bother posting anything before dA created the group system. Since I set a weekend deadline some entries will cover a sole mod or anywhere from three to five at a time.
In order of release.
Research and Development: Orange-box-group.deviantart.com
Human Error Episode 1: Orange-box-group.deviantart.com
Mission Improbable parts 1 & 2: Orange-box-group.deviantart.com
Factum Solus: Episode 1 : Orange-box-group.deviantart.com
Nightmare house 2: Orange-box-group.deviantart.com
1187: Episode 1: Orange-box-group.deviantart.com
Black Mesa: Orange-box-group.deviantart.com
Black Mesa Uplink: Orange-box-group.deviantart.com
I also reviewed Minerva Metastasis in the blog before this one.
If your pissed that I gave your favorite mod a bad review in the past updates I didn't bother to link too, well that's your fault for having poor taste. The ones I posted are some of my more positive ones for the mods that I enjoyed playing, and if you don't of like any those mods my advice is that you should uninstall Steam. 
10/12/11: Also hardcore nublets can go screw themselves, stop trying to make Half Life 2 and Portal play like Doom, Qauke and COD. Old school FPS twitchtardism should have died all the way back with the release of Half Life itself.
