I guess a two-handed sword is even more hero-y. They're chad enough they ain't gotta hide, plus you get cool sword-on-sword clashes. It's a nice mix between "ME STRONK" power and "I have mastered the blade" skill too.
Spear is a good weapon before someone mentions it, but it's the weapon of militias and soldiers rather than heroes. Hammers are a good choice, but the "thrusting the blade into the monster's weak spot" just looks best with a good ol' stabber.
Plus you get some cool poses with it.
So yeah, for pure Hero weapon it's the Greatsword. Link's a "wily adventurer" that becomes a hero however, so sword and shield works well for him. He's supposed to hide and block before retaliating in a skilful or cunning manner as opposed to jumping in the dragon's mouth to stab upwards into the soft palate.