It all depends how good a player you are. If you don't want to learn and just want to win easy then rapier or something similar with a fast move set is best. You don't have to learn boss patterns because you will always have stam left to roll, and you don't need to learn timings because your attacks are so fast.
If you want to kill bosses fast then using big slow strong weapons is much better, but because the attacks are slow and use a lot of stam you need to be a lot more wary. Zweihander, dragon ultra great sword and black knight halberd are all great at melting bosses, but if you don't know what you are doing then you will be caught with no time to react and no stam to roll.
Having a strong weapon can compensate for lack of skill, but in the end just learn to play the game, it's overhyped and really not that hard... For me I prefer naked zwei + grassblade sheild most of the time. You can get both very early in the game, and you can easily stay underweight (<12.5% is optimal) and maintain damage.
Every boss has their own strengths and weaknesses, there is no single enchantment that will beat them all, so it's best to stick with normal path weapon and use buffs to match their weaknesses.