We can't call this a mod, it's a whole new 200mb game based on the Build engine.
Standalone, does not need Duke3D to play, it's probably the biggest and best of its kind.
Download & Info:
review1:
review2:
And for those who wan't something quicker, Zombie Crisis:
a small 8 level 3.4MB standalone zombie arcade style tc!