Oh boy, "takes a deep breath"
So there's the original Hyrule total war with over 8 factions, each with their own individual units, buildings, hero units, and play styles. It also includes single player missions with hand crafted cutscenes and a LOT of fanfiction lore. https://www.moddb.com/mods/hyrule-total-war
The origional creator stopped working on it to instead convert it into Hyrule Conquest where he tried to do the same thing, but instead of modding Medieval 2: Total War, he modded 0 A.D, an open source 100% free strategy game. https://www.moddb.com/mods/hyrule-conquest
Your cohost post got me curious about the current state of the mods, and I discovered the following while falling down the rabbit hole:
Combined, the dude has been working on this for 20 years. Two months ago, he came out and said "I don't like Legend of Zelda anymore and I don't like the fandom so I'm going to stop and focus on the more fulfilling Freespace 2 mod for Star Fox.
HOWEVER, there are fans who have continued development of the original Medieval 2: Total War mod, doing not only bug fixing, but also expanding it. This was updated as recently as 3 months ago https://www.moddb.com/mods/hyrule-total-war-v-38-mr-nygrens-submod