You forget The WindWaker, where the King's wish drowns the land of Hyrule forever.
The Triforce's wishing power seems to operate under a rule-set similar to the Dragonballs, dispersing after the wish so that they can't just be endlessly abused, otherwise the climax of WindWaker would have gone
Daphneus Hyrule: Drown Hyrule
Ganondorf: Don't drown Hyrule
Daphneus: Do it!
Ganondorf: No!
Daphneus: Yah huh!
Ganondorf: Nuh-huh!
et al.
Link wished to destroy Demise in the present.
The inconsistency in Skyward Sword seems to be in how they treat Time Travel. The revelation that Zelda had to go back in time to take the place of the Goddess to seal away Demise (and eventually be awakened by Link in the present again) implies a stable time-loop theory of time-travel, whereby traveling through time was required to create the status quo, similar to the story of the first Terminator film.
However, the finale of the game has Ghirahim go back in time with Zelda to revive Demise early on, and Link go back in time to kill Demise, which he did, in the past. That dicks with the whole thing, because if Demise was revived but then killed, he's never around to set the events of the game in motion in the first place, and there we have time paradox. Unless Link's victory created another split timeline, but that's a whole separate kettle of fish
Monster Hunter: pissing me off since 2010.
