It's hard to answer that because there are a lot of hidden values in this game that haven't really been properly datamined and recorded
Like, every character's individual attacks have their own modifiers that aren't really listed anywhere in the community. Attack stat is hidden as well unless you actual equip a weapon, which makes me suspect that DPS is just calculated by multiplying a specific character's hidden value with the weapon's attack. So no autisming out perfection yet.
It really depends on character to character, i.e Nari isn't really reliant on her shitty skill and favors attack over skill damage, but there's not enough information for anyone to give you a definite answer. But generally I would just settle for having a high net roll. Marina likes everything, but I'd say having good subs is better than just max attack.