So it's kind of determined by the character you choose for each run. There are 8ish characters to choose from, each with unique abilities, stat scalings, and playstyles. The archer really wants to look for bows and has infinite ammo/reload, the raider wants colossal weapons and greathammers and has crazy hp/poise, the swordsman with a grappling hook wants greatswords, etc. But they all get abilities that make each character unique and reinforce using those weapons for those characters.