Imho there is absolutely no "best weapon" in the game. It's all about how you like to play, each weapon has their own style to fight.
Unfortunately most of the weapons are useless and only few are actually good when you have all the end game gear available.