A hero’s name?

I think we mainly assume that a hero will be called Prince Caspian or something similar. Being of noble blood, and handsome. Fairytale books and films lead us to this definition. Only stories like Beauty and the Beast where at the end the Beast turns into a handsome Prince slightly subverts this.

But what happens if the hero has an ordinary or odd name? Maybe Euphonio Grunt-Ffungus? His name being a long lost memory from generations ago of the families profession of truffle hunting!

What heroical task would Euphonio complete? Would he rescue a cat from on top of a giraffe? Fight off a venomous kangaroo? Hide chocolate from a dragon? Kill a giant spider that’s threatening to engulf the palace?

I think this kind of hero would be in a comic fantasy, not a serious story. But we cannot chose our names, let alone our ancestors.