OCARINA OF TIME LINK WANTED NOTHING MORE THAN A FAIRY SO HE WOULDN’T BE AN OUTSIDER HE DIDN’T ASK TO BE THE HERO OF TIME HE DIDN’T ASK FOR THE TASK OF SAVING HYRULE HE JUST WANTED TO BE HAPPY
And he didn’t even get that happiness. No matter which timeline you look at, his fate is lousy–either he’s killed by Ganondorf in battle, vanishes completely, or after saving Hyrule and Termina, he has so much emotional baggage that he becomes the Hero’s Shade after his death and can’t cross over.
OUCH
And he didn’t keep his fairy for very long.