The best dwarf I ever had was Fath Allosoltar. In that particular fortress, I had settled on top of a kobold campsite, so there were about 4 kobold archers milling about in the corner, with a dead one. (I knew about the location when I embarked, I had lost 2 adventurers trying to get them, dem archers, man)
Anyway, These kobolds were friendly, due to the known bug, so I could take the stuff that was on the ground, mainly a dropped bow and some iron arrows.
Now Fath wasn't very interesting, he and his wife had migrated to the fort early on in it's life, and he had no useful skills whatsoever, so I was making him fish.
One day, as he was heading back inside after a days work, he bumped into a sneaking kobold. I immidietly went into the military screen, and assigned a small group of fit dwarves together, along with Fath, I was hoping that Fath might slow down the kobold long enough for someone stronger to get there, since he was unarmed.
Now he didn't stop the kobold too well and it started to get away, a woodcutter with an axe was coming from another direction, so he would have intercepted the thief, but another kobold popped up and distracted the woodcutter. But the first one still didn't get away, luckily Fath, although physically weak, was rather quick for a dwarf, and caught up with him, and grabbed his arm. The thief stabbed Fath in both legs, crippling him and making him fall, but he still held on, and after the woodcutter had finished off the distraction, he jumped in and beheaded the kobold.
The wounds in Fath's legs were too bad for him to get up and go home, and he lay there for help that wouldn't come, as I had no hospital. I quickly began to assemble a hospital, but for some reason nobody would go and help him. After over 2 months of inability to walk, Fath stood up, walked home, and went to bed. Fath was the first dwarf in the fort to be injured in battle.
After that, I decided that he should never be in melee combat again. I equiped him with an artifact robe for protection, as I had no proper armor, and gave him the looted kobold bow and arrows.
Later on in the fort's life, as everything was going well, and the fort's population sat at a safe number of 79, a dwarf gave birth, and in that instant, a Titan showed up on the map. I was still a new player at the time, and this was the first time I had ever seen a titan, let alone know how to handle one.
The titan ravaged my pasture, and threw a farmer into a nearby pond, killing him. Luckily a yak managed to get a lucky kick in at it's foot, and it had to limp it's way into the fort. I had prepared the fort in case of invasions, and so I had a spot where I could set up my dwarves behind a defensive line of fortifications, where they would pepper the beast with bolts until it fell.
At that moment I had a realization.
I had 2 dozen marksdwarves, and 2 dozen crossbows, and not a single bolt.
The Titan limped it's way down into the fort, and my army began to run back to the door, to face it in melee on the other side, but the fight was already over. Fath, the only dwarf with any ammo, took a single -iron arrow-, and made the titan's upper and lower bodies distant relatives. The combat log was only 2 lines long.
Fath later ended up having 2 children, one of which died from going berserk, and he made an artifact crown, made of cow bone.