Damage scaling stats: Strength, Dexterity, Faith and Intelligence do nothing interesting for the game, the only purpose is to lock you in a specific group of weapons, this does only decreases the option a player has it has with almost no balancing benefit, i would prefer to have a single generic Damage stat so I can use and combine every weapon i want (for example Cleric’s Mace + bow and a off-hand Claymore and i could swap the bow for a shield of choice that looks like i want instead of being forced to use a different shield that is the same but has the right scalings but doesn’t fit the look of my character).
In case you don’t like this approach and you think that the stats choice is essential for the game genre, I also have a different solution/exemple inspired by Elder Ring.
In case you don’t know Elder Ring system: In Elder Ring Strength, Dexterity and Arcane have some perks: Strength increases by 50% when 2 handing, Dexterity increases casting speed of Sorceries and Incantations (and also reduces fall damage and also makes it harder to fall off the horse for some reason?) and Arcane increases status buildup (and also makes you slightly more lucky).
Faith and Intelligence are basically just stats but intelligence is focused attack options and some utility and faith is more about utility keeping them separate is mostly important for balance in the mid to early game were buffs + mana efficient range options should not met the most important part of this all system is that EVERY NON UNIQUE WEAPON SCALING CAN BE CHANGED an in this way you con use the weapons you want with the spells you want or with status build up or with 2 handed bonus damage or some combinations of this
My secondary Idea is something similar to: have Strength increasing CA (Chargeable Attacks) (Runes Included) Damage, Dexterity increasing CA (Runes Included) Speed, Faith increasing elemental buildups,
Intelligence increasing focus gain or elemental proc damage/effects
and most importantly EVERY NON UNIQUE WEAPON SCALING CAN BE CHANGED. This solution of course is way harder to balance and the details of it are really up to you for example Strength might increase CA (Runes Included) Damage and Speed and Dexterity might increase attack speed or reduce stamina consumption etc.