My build in bloodborne was almost enitrely built around a single late game weapon which is the Chikage. It is a katana that has S scaling with bloodtinge and in the transformed mode it drains your own healths but has a ton of damage.
I Souls games I tend to find myself going down the magic path more often because some of those spells can do amazing amounts of destruction on many enemies at once. also in this case on Dark Souls 2 I built my magic around having the Moonlight greatsword which scaled pretty well with int and its second attack was a ranged strike that damaged anything in its path.
It is sort of strange but I always seem to end up building my characters around very specific weapons due to their scaling in stats of the types of character I want to use.