extremely silly dwarf fortress mod idea: adds guns to the pool of items that can be made as artifacts and found as "treasures of the gods". they cannot be produced in any other way.
a dwarf making a gun as a strange mood artifact (and not via possession) would max out their engineering-related skills.
also you would be able to make ammo for guns on the condition you have at least one owned by your fortress
dwarf makes a gun called "the staff of dragons" and it's made of candy with decorations of black diamonds, elf leather, and has a dragon motif made of malachite
