I like a lot of these ideas, especially the soldier vs. warrior one. Here's my 2¢ worth:
Weapon balance is mostly okay. Mostly. It's ARMOUR that desperately needs looking at. Currently, an unarmoured goblin Elite Crossbowman can and will lay waste to your Legendary Armour User adventurer in full masterwork steel plate armed with an artifact Adamantine two-handed sword and an artifact Adamantine shield. Why? Because armour doesn't defend you the way it *should*.
It's all well and good to absorb damage, but when you get right down to it, well made steel armour WILL prevent a point-blank crossbow bolt from piercing your heart. Your side? No, probably not. But your chest is NOT going to take a hit from a bolt. The bolt will dent the armour and bounce off, or in some rare cases would make a shallow indentation and stick there. If not fired directly at a flat area, it would in all likelihood simply be deflected.
*Good* platemail is very curvaceous. There are few if any flat surfaces, because a flat surface means a spear, arrow, or crossbow bolt will easily puncture the armour. You *can't* wear extremely thick armour and expect to be able to move in it, and as a result, the plate is only a few millimeters thick. The idea is not that a greatsword to the head will be blocked anime-style - it's that the greatsword will slide off the side and hopefully then slide off of your shoulder, or lose too much force to cleave your pauldron and cut off your arm.
So, yes, maybe the crossbows and bows need a slower rate of fire or require loading between shots (is 'r' mapped to anything in Adventurer mode? Could use that), but what armour does really needs to be revamped in order to implement a diverse set of effects weapons can have, and to make crossbows NOT destroy anything and everything you fire at.