Ah the memories of when I'd draft up my own Zelda game. It was so freaking awesome. I thought I was so original that Link had to learn how to use and manipulate the powers of the elements (water, fire, earth, air) and then I discovered that Avatar was a thing and there went my idea.
So it was transformed into something else and to make a very, VERY long game much more shortly summed: The game is called TLOZ: The Warrior of Ages
After Link's village is attacked and burned to ground by a dark army of monsters and they ask him to appeal to Zelda for aid. But the problem is Link's village is one of only many targets by Ganon as he systematically razes Hyrule to the ground before aid can arrive. Link meets Zelda and she immediately has a hunch that Link is the young, blonde hero of ancient prophecy called the Warrior of Ages.
She believes only this hero can beat Ganon so she has Link visit an oracle who indeed confirms to be that hero. Link is given numerous temples to conquer (think fire, forest, water etc... all the good stuff is there) but these temples were divinely designed by the Gods to be a test for this hero and teach him the skills necessary to conquer the great evil and give Link more items to use. At the end of each temple Link learns a new piece of information (be it pieces of a map or song I can't decide which) that gives him the location of a sacred shrine that houses the Master Sword. In the meantime Zelda has long since abdicated her throne because Ganon made an ultimatum that more people would die unless she stepped down. Needless to say Zelda's approval rating is 0% and most of Hyrule is spinning because they feel betrayed by their princess and openly rebuke her.
So anyway after beating enough temples and gaining some awesome weapons, Link finds the shrine and gets the Master Sword. Almost immediately he is tasked with conquering the game's last temple which is an equivalent of the Shadow Temple (which used to be a normal temple since desecrated by Ganon's presence) in order to purify it of the evil inside of it. Shortly after Link gets a message from Zelda to meet her in a hotel in Kakariko village and when Link is ready, it's time to team up and whip Ganon's candy ass. They team up, Ganon is beaten and there ya go.
There's so much more I haven't gone into but believe me it's intended to be interactive as can be including regular horse racing that you can win money on, archery contests, fishing at huge ponds, a strongly implied love interest for Link and a little chapter in the middle of the game that I call "payback time" where Link and one of the leaders of the Goron Village head out together after victory at the fire temple and team up to decimate Ganon's army using hundreds and hundreds of explosives and instead of riding out on Epona, Link is riding out on a giant Dodongo that is very... VERY angry and even more destructive. Let's just say they do so much damage that they effectively blow up most of the mountain.