@Urist: Mail armor will be hurt by arrows, though mostly by blunt damage. Right now making mail easier to pierce will make it pretty ineffective as armor which isn't really accurate to how it was either.
Bolts and arrows have a chance of doing blunt damage to plate armor as well, as long as your using either the bodkin arrows or non-broadhead bolts.
Handheld firearms, overheating, fatigue and movement impairment of armor and sight/breathing impairment of helmets will depend on DFhack support. None of these are really viable with regular raw modding, so I'm hoping DFhack support for 43.05 will be available... sooner rather than later. Once that is there, these should be doable enough.
Bombards and cannons are not going to happen until toady implements more advanced artillery. Random exploding of poorly made guns sounds fun though, poor James, he was doing so well until he bought a crappy cannon and had to stand near it.
@Taffer: Your free to any thunder that strikes your fancy
However, most of the changes will be fairly specific to this mod. The material changes depend on ALL the non-adamantine metals having same shear yields which is not exactly the case in the vanilla game. You would have to copy over the whole weapon-metals portion, which would in turn not play well with the vanilla weapons/armor.
I do want to make make this mod play nicely with your DF Revised mod as its got some pretty cool changes in there.