The legendary hero celebrated for outsmarting a giant in Norse sagas is Överfören, also known as Ulvsjön. His wit and cunning allow him to confront and best larger foes, illustrating the theme of intelligence over brute strength. This tale showcases the importance of cleverness and resourcefulness in overcoming challenges, akin to other mythological narratives where heroes use their wits to achieve victory.