Yes - if your character lives long enough to get good STR and DEX stats, light weapons will hit the limit of attacks per round and heavy weapons will start to close the gap.
Some characters such as early mages are too weak to get an extra attack with a dagger - for them, heavier weapons are more reliable in an emergency.
Some heavy weapons are also worth wielding for the abilities or immunities they provide, provided the character can compensate for the loss of damage-per-round with bows, spells, or stealth.