(Source: Storm King’s Thunder, Page 116)
The quest for the Giant Slayer (or some other needed weapon) can be any variant of the Prodigal Son story. It could even be the biblical version where the party finds Harthal slopping pigs with nothing but a loincloth to his name.