The End is Near

Question: You know how there's that prophecy that says Zeus will be killed by a child of his? How many examples of this sort of situation exist in myth? I ask because I'm using Comprenion as a major antagonist in a game, and destined deaths of gods are a big part of the antagonistic Fate Titan's agenda.

Ooh, neat. Enforcing Fate, even when it's horrible and unpleasant (or especially then?), should always be on the Fate Titan's agenda. It doesn't care about your squishy little feelings. It cares about destiny.

There are actually a lot of examples of the foretold downfall or death of a major figure in mythology, but Zeus' case is rare because it hasn't happened yet. Most of the time, the prophecy comes to pass within the same myth that it was delivered, meaning that there are very few open-ended prophecies of death lying around. One example would be Balor, who upon learning that his daughter was destined to bear a child who would kill him locked her up in a tower, only to be thwarted by Cian's wizardly powers and eventually killed as predicated by his grandson Lugh at the second battle of Maige Tuiread. The prophecy is immediately followed up by myths that show it coming to pass. Another would be Ra, who forbade Nut to have any children after foreseeing that one would overthrow him, only to fail when she sought Thoth's help to give birth and thus created Isis, who stripped Ra of his power, and Osiris, who took his place.

There's actually a great reason for this; it's because such myths, which progress from foretold doom to realized fate, reinforce the idea that destiny is inescapable and incontrovertible. By showing the unlucky main character's understanding of his fate and attempts to avoid it, the final moment when he fails reminds the audience of the tale that one's fate can never be avoided. Often, the actions taken by the doomed person are what actually causes his death (such as when King Laius abandoned the infant Oedipus in order to avoid the prophecy of his son killing him, thus making it possible for the child to grow up without knowing him and later kill him by accident), also suggesting to those who hear the tale that trying to avoid your destiny only makes things worse.

Most prophecies are storybound, so it's rare for a prophecy to still be unfulfilled - in essence, that means that your Scions are still in that story, and they've entered it in medias res somewhere in the middle between the speaking of the prophecy and the eventual end which hasn't happened yet. It's easy to do that with new prophecies you make up for your game, but harder to find ones that were part of some other as-yet uncompleted story.

However, your biggest and easiest targets for this are the Aesir, sort of en masse. The prophecies of Ragnarok are very clear that they are going to die, and give very specific details of how; Baldur will be killed by Hod as a result of Loki's interference, Nanna will kill herself out of grief, Hod will be killed by Vali in retaliation, Loki will be exposed and bound underground until he escapes to lead the fire giants into war against the pantheon, Odin will be eaten by Fenrir who will in turn be killed by Vidar, Thor and Jormungandr will kill one another, Tyr and Garm will kill one another, Heimdall and Loki will kill one another, and Freyr will be slain by Surtr because he lacks his famous sword, which he long ago traded away in order to woo his wife Gerd. These prophecies are exactly that kind of "in-progress" story; the foretelling has already happened and the Aesir are aware of their prophesied doom, but it hasn't yet happened (although some of the groundwork, such as Thor's established enmity with Jormungandr and Freyr's loss of his sword, has already been laid).

Keep in mind also that many cultures don't conceive of prophecy and predication the same way - it's mostly Europe that is fond of very definite "This is going to happen" prophecies. Many cultures in Asia prefer an if-then model - if thing A happens, then thing B will happen - meaning that disaster can be staved off as long as thing A is prevented (which can be a long time but is usually not forever - they may have a different concept of Fate, but it's still usually triumphant in the end). Among the Orisha, such strict prophecies are almost unheard-of, and nobody ever has a destiny they can't avoid; their concept of destiny is that it is something that is ever-changing and must be worked at hard to be achieved, so they have their hands full trying to make sure their Fate does come to pass, rather than trying to avoid it (and they believe that failing to realize their destiny means that they've generally failed at their entire life). Comprenion must encompass all of the ideas of Fate expressed in various mythologies, so don't leave these guys out just because they're doing it a little differently.

The Titanrealm of Fate loves enforcing destinies. It's what it does, and if it's mad at a pantheon, heaven help them (see: Aesir, all dying, prophecies of). We love involving PCs, especially ones who dabble in Fate purviews themselves, in those great foretold events so they can see it in action firsthand. Tell us how it goes!