http://fose.silverlock.org
http://www.fallout3nexus.com/downloads/file.php?id=4447
Playing With Firepower adds a bunch of different weapons with exotic or unusual scripted effects, all creatable at a workbench from more common ones.
The first set are weapons that reflect off walls, chairs and people, thanks to the magic of Maths:
http://www.youtube.com/watch?v=0gt5peMjP2U
The second set are variations on the missile launcher that use 'Aim' as a control:
http://www.youtube.com/watch?v=-j-A9Yk70WY
The third set are a couple of weapons from Valve games:
http://www.youtube.com/watch?v=c2885r6Vya8
The fourth set are a collection of remote explosives ranging from the self-explanatory Remote Mininukes to Glue Bombs that stick your foes in place, and Gore Bombs that cause enemies to flee in terror. You can detonate in a variety of ways, including chaining them in sequence:
http://www.youtube.com/watch?v=mAFXuC8Kqjo
There's also a http://img838.imageshack.us/img838/417/standing.jpg http://img801.imageshack.us/img801/6577/shooting.jpg, because why not. Oh, and a glue gun using the glue bomb scripts.
Most of these weapons (apart from the remote mines) work for both players and NPCs, with a few exceptions (NPCs can't intelligently use guided missiles, for example).
http://www.youtube.com/watch?v=wufYZiPePpY
Fun to play around with, ain't they?
-----
Thanks for the feedback on the WIPz thread, the weapons are all workbench-produced as a result. They're also not in levelled lists- unfortunately it turns out there are no boss-only weapon lists, like oblivion :shrug:.
Anyway, questions, comments, suggestions etc. in the thread please!