Imagine you give the rights to the entire "Hyrule Historia" to Peter Jackson and you might BEGIN to approach how insanely aspirational the "Hyrule: Total War" Mod is looking. The result of years of work helmed by the Parallel Process Team (link), the final product will have you controlling armies from across the history of the Legend of Zelda including Gorons, Zora, Stalfos, Gerudos, Twili, and even some crazy-ass units from "The Church of Majora".
"Don't spit until you see the whites of their eyes!"
"War is hell, but then again, so is the Water Temple."
There's an impressive amount of lore-building going on, with characters from across the franchise being incorporated into one unified world. The premise builds upon the question: What would happen to Hyrule without the Hero of Time? The result is a Game-of-Thronesian murder frenzy as factions battle among themselves on land, sea, and desert. It's a pretty clever idea since Nintendo usually potrays the violent transfer of power as "Ganondorf pushes over an old man". Check out the trailer below to see the mod in action.
To start playing you'll need a copy of Medieval II: Total War and the files available on Mod-DB.com (link) and fair warning, like many (non-Skyrim) mods it might take some fiddling before you get it to launch smoothly. If you just want to see cool photos from the devs, you can check out the Hyrule: Total War Wiki. It's plain to see there's a lot of imagination at work here, but I'm still waiting for Nintendo to deliver the Kokiri vs. Moblin bloodbath I've waited my whole life to see.
"Alright, the next one who calls me 'Elrond' gets a normal boot right in the ass."
"Sisters, I fear our training in the ancient art of Gender Concealment is of no use right now."
"Are you my mommy?"