I has some more cool mods :3
Have the Dwemer pistols like I said before, better blood effects, ragdoll changes, a bunch of small things here and there, but the three I wanna share are Civil Unrest, Explosive Arrows, and Dwemer Certified.
The first adds warzones to the game, the third is bunch of Thief inspired special arrows, and the third is Dwemer crafting.
I haven't testing that last one yet, but your supposed to be able to build, Enchant, enhance and even control Dwemer constructs, and each has a value. To keep them around, you need to give up that value worth of Magicka. So you can have a bunch of Spheres or a few Centurians walking around.
As for the first two... let me put it this way. Right now, I'm raining firebomb arrows down on a warzone where a dozen or so Necromages are having a battle with their undead armies. There looks like there's about 50 to 100 people involved. I'm just carpet bombing the whole shebang with what could only be described as long ranged molotov cocktails.