To start off:
Best Mods of 2005
http://features.moddb.com/218/?fpage=0
It's rather narrow minded, though (they're all 3D, FPS mods with one or two exceptions).
Depending what people like, there is much more of interest than this. I'm finding out more and more about the mod scenes in various games. Some impressive stuff.