I think that if you increase strength, you should increase the physical damage of weapons, if you increase dexterity, you should reduce the cost of using stamina or at least your movement speed must be increased. Intelligence, for example, should increase damage from rune attacks, and faith, for example, should speed up the use of these rune attacks.
In that case, all weapons in NRFTW should not require any attributes. That would be ideal, wouldn’t it?