The Greek hero known for his journey to the Underworld to retrieve his wife is Orpheus. He ventures into the Underworld after the death of his beloved Eurydice. Armed with his enchanting music, Orpheus charms Hades and Persephone into allowing her return to the living world. However, he ultimately loses her due to his disobedience, making his story one of love, loss, and the power of art.