There's plenty. The Zodiac Braves, for instance, are all mythical heroes, and what we have in lore on them comes from the legendary weapons they wielded. The various Relic Quests give quite a bit of insight.
http://forum.square-enix.com/ffxiv/threa...-lore-post
A-Towa-Cant, Shatotto, Wiyu, Iron Eater, Sasuke, Ivon Coeurlfist, Mirza, Jhal Tristram and the Sultansworn wielders of Joyeuse and Durandal, Haldrath and Saint Reinette, Gilbert, Golbas Rombas... and so on.
http://forum.square-enix.com/ffxiv/threa...-lore-post
A-Towa-Cant, Shatotto, Wiyu, Iron Eater, Sasuke, Ivon Coeurlfist, Mirza, Jhal Tristram and the Sultansworn wielders of Joyeuse and Durandal, Haldrath and Saint Reinette, Gilbert, Golbas Rombas... and so on.