This applies to every single physical weapon in the game (no mods).
You could be an escaped, insane convict stabbing everyone with a shiv, or a deranged hunter who cannot kill a deer, so he hunts weak humans with his longbow, or you might be a blood-thirsty knight smashing people to bits with your dragonbone warhammer.
The choice is yours...
Personally, my favourite weapon thus far is the Enhanced Crossbow (I haven't gotten far enough in the DG story, yet) because I'm a marksman at heart, I love the satisfaction of making a decent shot, and I like the elemental bolts.