You won't like the answers.
Bows do not have any way to do more damage than their set value. You can increase your crit damage and chance to crit, but it will never come close to doing the same thing with a sword.
Accuracy never needs to upgraded because it increases with each level.
Dexterity will give heroes a crit damage bonus, but it won't match up with Strength's damage bonus. It will give you some dodge, but since accuracy goes up every level, dodge is only a factor in the early game. After that every unit will hit every time almost.
Intelligence increases XP per battle, Spell Mastery, and Spell Resistance.
Spell Mastery increases the likelihood of a successful casting.
Spell Resistance protects you from spells. So in a battle between Mages, the higher intelligence wins.
Magical damage can also be increased by capturing shards.
Keep in mind that this is very early in the public beta. We need to point these issues out though so that everyone knows what they are dealing with in the current version. There will almost certainly be balance done to make each stat more useful. For instance, it looks like bows are supposed to do excellent crit damage as Dexterity goes up. It is unbalanced right now, so we don't see it happening and bows are thus static in damage.