In fairy tales or folk legends, knights always go off on these sprawling epic adventures and quests, and nobody gives a shit what happens to them in the end. They finish and go home and the story wraps, or they die. If they go home, we never know what happens to them.
I'm not saying I'm a knight or a hero. I'm just saying at the end of a lifelong quest? You get bored and you drink a lot and you start to wonder if it was worth it at all. Then you just take a nap.
Wouldn't make for very good endings to epic poems. Better to leave Ulysses sailing off and leaving his son in charge.