In Naruto; there are the two male versions of this; Chosen ChildrenNaruto and Nagato who were destined to bring a new golden age to the world.....or bring it into complete and utter ruin; the latter took the second road at least until before he died while the former still remains the saviour...for now.
In Tengen Toppa Gurren Lagann, Nia turns out to be a virtual lifeform that acts as an agent for the Anti-Spirals. Played at its straightest when she puts herself between the heroes in their Giant Mecha and the keyhole that will allow them to take control of the moon and keep it from crashing into the Earth (said keyhole having a key that also happens to be a giant drill).
This is, not incidentally, the point where most first-time watchers start baying for the blood of the show's ultimate antagonists. Not because of The End of the World as We Know It - that's just what villains do, you can't really hate 'em for it - but for doing that to the insanely MoeWoobie Nia.
Hotaru Tomoe (Sailor Saturn) from Sailor Moon. The Outer Senshi misunderstand her job thinking it is a bad thing (And confuse her with Mistress 9 who's possessing her and is The Antichrist) and try to prevent her from awakening. They fail and she explains her job is to serve as a reset button in the event that the bad guys win, allowing Moon to restore the world into its proper form. She doesn't get to destroy the world in the anime (she defeats the Big Bad with Moon's help, then is reborn as a baby), but does in the manga; Sailor Moon restores it moments later.
One of the main characters of Blue Seed gets this status near the end of the series...
In Mahou Sensei Negima!, Big Bad Fate Averruncus wants to erase Mundus Magicus and put its inhabitants into a Lotus-Eater Machine to keep them from disappearing when Mundus Magicus collapses on its own. And it turns out that he needs Asuna's Anti-Magic abilities to do it. But in the end, Fate and his group are defeated, and Asuna channels her powers through a World-Healing Wave instead.
Scrapped Princess is the obvious example - there, the main character, who is also the eponymous character, basically lives this trope. 99% of the world wants to kill her because she's destined to bring about The End of the World as We Know It, while the remaining percent wants to protect her because it's not HER fault. Resultantly, we've got both 'villains' who are really just scared people who are afraid to see their world collapse around their ears, or obeying orders from up on high... and REAL villains who are manipulating events for their own advantage, with complete disregard for the number of lives involved. Not to mention some of the 1% that help her are pretty crazy.
Slayers, more specifically the second season (NEXT), may have fallen into this. When the team is facing the Big Bad, Lina wonders if she should fight it because a) she doesn't think think she can possibly win and b) the only way she can win is with a Dangerous Forbidden Technique called Giga Slave that has a high chance of wiping out all existence. At this point, some of the members have to warn her that under certain circumstances, they may have to fight her. Turns out that the trueBig Bad wants her to use the technique and tries to force her into it, because the ultimate goal of demons is to return the universe to empty blackness.
Sonic X: Cosmo turns out to have been implanted with an audio and visual tracking device allowing the Big Bad to see every single move she makes, thus leading them right to the good guys the whole time, basically dooming their every effort. Cosmo angsts about this considerably, Shadow just outright wants to kill her and even just removing the transmitter would blind and deafen her permanently, and everyone else rallies to her side deciding to defeat the Big Bad even with the transmitter. She still dies, in an Heroic Sacrifice
Hayate Yagami of Magical Girl Lyrical Nanoha A's, the latest friend of Nanoha's group during that season who also happened to be the latest master of the Book of Darkness, a rather hazardous title considering how all previous masters died blowing up their worlds after the book possessed them and went omnicidal. Much discussions about the cruelty of fate were had.
In the second season of Darker than Black, Yin ("Izanami") ends up as one of these. Although the Gainax Ending and Mind Screw make it hard to say for sure exactly what happened, it appears that she was possessed by an Eldritch Abomination but managed to suppress it for a while; when it woke up, she causes Contractors to commit suicide and attempts to reach Hell's Gate. When she's met there by her counterpart "Izanagi" (Shion), she can cause the Gate to open, which, whatever it does, can't possibly be good given what we've seen of the place and some very apocalyptic-sounding prophecies from Amber. Hei spends most of the season trying to find her and kill her to prevent this. He ends up basically exorcising her instead.
In a rather weird example, Haruhi Suzumiya can bring about the end of the world on a whim, and she does not know it. Everyone tries to keep her pretty happy and/or occupied, so her subconscious doesn't act on such things. Although Kyon tends to push this when he gets annoyed at her.
Mayo Sakaki from the 3rd Fushigi Yuugi OVA. She very nearly destroys the entire Universe of the Four Gods just to get a fairy-tale ending with Tamahome. Little does she know it's a sort of Batman Gambit deployed by Miaka to save the Universe of the Four Gods!
In Clamp's X1999, Kamui and his best friend Fuuma are "twin stars" - one destined to save the earth, the other destined to destroy it. Kamui chose to save the world, so Fuuma got stuck with the role of destroying it, along with gaining a evil personality change to go with his Face-Heel Turn.
To clarify, Fuuma is destined to fill the empty seat left when Kamui picks his side. If Kamui were to join the Dragons of the Earth, Fuuma would go to the Dragons of the Heaven. But Kamui chooses to join the Heavens, so Fuuma goes to the Earth. Either way, destiny is skewed toward the Dragons of the Earth winning. Meaning that there will be a catastrophe that wipes out mankind, but other life goes on. The only version where this really means that Fuuma is a Slasher Smile maniac is the animated movie, though. Otherwise, he's still as Gray and Black Morality as everyone else in the series.
In Recordof Lodoss War, it is revealed that Little Neese, the girl that spends most of the first part of the show sleeping in the arms of several of the older characters, or as an extremely shyteenage priestess in the second is one of the three key objects for a ritual that will destroy the entire continent. As there's no place where she would be safe from being kidnapped by the evil sorcerer and she has known her condition as an Apocalypse Maiden ever since she was young, she rather takes her chance and tries to take him down before he finds her.
Macross Frontier has Sheryl and then Ranka engineered to affect the Vajra with their singing and keep them off the Big Bad until she can use Ranka to pull off an Assimilation Plot for the entire galaxy. Also, Ranka's pet Ai-kun counts to some extent since the cute little critter is eventually revealed to be a larval Vajra which takes Ranka back to the Vajra homeworld for use by the Big Bad.
Miharu from Gasaraki seems to be one. In the end, the real one is Yuushiro's little sister Misuzu.
One Piece: Luffy actually became this in the Fishman Island arc (or at least was believed to be one), where the fortune teller Madame Shirley foretells a boy with a Straw Hat who will spell doom for Fishman Island.
And near the end of that arc, we have Shirahoshi, who is said to have a power able to destroy the whole world and is mostly unaware of it. Past uses of this power back up this claim pretty well.
In the Ah! My Goddess movie, we have none other than Belldandy herself. With a good chunk of her memories gone, her heart in great turmoil due to believing that Dark Magical Girl Morgan has won Keiichi over andThe Virus invading her body, the Anti-Villain Celestine uses her to hack into Yggrasil's system and try resetting both Yggrasil and the Earth to wipe away all suffering...
The eponymous character of Hellboy is prophesied to bring about the end of the universe.
Uncanny X-Men #137, "The Fate of the Phoenix". The Phoenix Force, pretending to be Jean Grey, was so powerful she could no longer control it, and became the Dark Phoenix, risking the destruction of the universe. She eventually made a Heroic Sacrifice to end the threat. It gets retconned back and forth all the time whether it was actually Jean or the Phoenix Force pretending to be Jean who did this, but it fits the trope either way.
Also done with Colossus in Whedon's run on Astonishing X-Men: the Augurs of a Planet OfBlood Knights called Breakworld predict he will destroy the planet, so they try to kill him in various ways, starting at developing a mutant "cure" and ending in blowing Earth to vapor. Fortunately, though an organization of Well-Intentioned ExtremistSpace Police are not exactly on Colossus' side, the whole "kill Earth to kill mutants" thing has them pretty pissed off - they're not interested in killing Colossus, because if they can't make the bad guys quit trying to kill Earth, they can have Colossus kill them all. Pragmatism at its best/worst.
Gambit of Earth616 was also fated to destroy the world by losing control of his Omega-level mutant powers and cannibalizing the energy of the whole planet, and in many universes he already had. In fact, everything that happened in his life before X-Men was the result of an alternate universe version of him manipulating him into going back in time and arraging things so that the events surrounding his prophecy would come about sooner. Everything from the Thieves Guild's allegiance to the immortal Candra, to Mr. Sinster's shapeshifting powers, to his own father adopting him were because another version of himself (powerful enough to single-handedly destroy the Phoenix) had already become a World Eater and was trying to stop it from happening in other universes.
Captain Atom in Captain Atom: Armageddon discovers that he is going to destroy the Wildstorm universe if he stays there, and that he also can't leave, and that if he dies, the destruction will happen instantly. In the end, Nikola cures him and sends him home. Then she destroys the universe. But then she remakes it.
Played with in Les Légendaires during the Anathos Cycle; the story starts with the protagonists learning that one of them is gonna serves as a host for the reincarnation of a Omnicidal ManiacGod of Evil known as Anathos. When they finally find out which one of them it is, it turns out to be Shimy, the group's elf. Team Leader Danael then pull out a Batman Gambit to prevent Anathos from reincarnating into her... only to end up Out-Gambitted by the God, who turns out to have planned this and reincarnate into him instead.
In The Sandman, Rose Walker is a variation; she is a "vortex", whose existence causes the barriers between different people's dreams to break down, which drives them mad in the short term, and since dreams have the power to literally shape reality, she would ultimately destroy the world. The damage she could do is so serious that stopping a vortex is the only situation where Morpheus is allowed to actually kill a mortal.
In An Extended Performance, Princess Celestia fears that her younger sister Princess Luna may be this: if she isn't stopped, she will freeze the entire world with the The Night That Never Ends. The problems are that Nightmare Moon is hideously powerful, and Luna is the pony whom Celestia loves most of all in existence.
In Nightwatch, the center of a coming apocalypse causing storm is a seemingly normal Innocent Bystander. As the story goes on, we discover she is an Other (basically a witch) who is riddled with guilt over manipulating her mother into rejecting a life saving kidney transplant by revealing she was the donor. The spiraling guilt would have destroyed the world had Anton not talked her down (er, up?) from her depression. In the process, he gained a love interest for the next movie who was also one of the two most powerful Others in existence. This is (somewhat) subverted in the novels. The apocalypse was actually a feint by The Dark Side to convert her, rather than being caused by her own actions.
In The Amber Spyglass the priests send an assassin to whack smartass kid Lyra because it is prophesied that she will be the new Eve and bring about a new fall of Man. Just one of the many reasons why there'll never be any sequels of The Golden Compass...
In Nick Kyme's Warhammer 40,000 novel Firedrake, it is established beyond a doubt that Dak'ir is the person prophesied to destroy the planet. They imprison him while deciding whether to kill him, at the end.
To clarify, Dak'ir is prophesied to either destroy or save the Salamanders' homeworld, Nocturne. This gets resolved in the third novel of the Tome of Fire trilogy. He saves the planet, though he also comes damn close to destroying it.
A variant in Ravenor, where Carl is the prophesied host of the demon Slyte, who is set to bring about unimaginable destruction, but nobody realizes it until it's too late to save him.
In Smallville, Chloe Sullivan becomes this when she is possessed by Brainiac. She hacks every computer and hypnotizes half the world, intending to download all information before making Doomsday destroy what is left. The Legion arrives and prepares to kill her as they think it is the only way to get rid of Brainiac for good, but Clark convinces then to figure out a way without killing her.
Supernatural, with Gordon (and associates) trying to kill Sam before he can go bad and lead demon armies to conquer the world.
Gordon isn't the only one who has it in for Sam. His own Dad was afraid killing Sam might be necessary some day (which might go a long way in explaining the guy's obsession and control issues).
Even Sam thinks his own death might someday be necessary. He made Dean promise to kill him if he ever went bad, and in Season Five he even swore to Lucifer that he'd kill himself before giving in. Not that suicide would do any good.
But then the angel Anna says no problem, they'll just kill Sam and prevent Lucifer from bringing him back to life by scattering Sam's molecules throughout the entire universe. Apparently not even this will work.
The X-Files has this at least three times: the people in the snake church rape and impregnate their leader's daughter with some sort of anti-Christ, both main wives and all past ones in "Terms of Endearment" against the demons will - he was just trying to have a normal family, and Scully herself in a season 9 episode. The worst part of that last example is that Scully is pregnant with William at the time, searching for a lost Mulder, and just getting used to a newly-added Doggett.
A major theme in Luca Turilli's album Prophet of the Last Eclipse, particularly the song Demonheart.
Mythology and Religion
Shiva is said to dance the dance that creates, sustains, and destroys the universe all the time. However, it is specifically noted that he does this when his wife, Sati, sets herself on fire after being insulted (by her father) for marrying Shiva in the first place. It took Vishnu's discus cutting up Sati's body to stop Shiva from completely destroying the world. Similarly, Shiva acts as a Barrier Maiden when his wife in another form, Kali, goes on rampages.
Princess Elise in Sonic the Hedgehog (2006). Iblis, the immortal fire monster, is sealed inside her and will be released to destroy the world if she cries.
Another example might be Devil May Cry 3. It turns out that everyone involved (except Arkham, who's orchestrating it all) is required to open the gates of hell, meaning that if any of them had died before then, hell can stay closed forever. Of course, it was prophesied that the Sons of Sparda would save the day, so it may be a subversion (odd in that the demons seem have it out for them)
Bastila in Knights of the Old Republic possesses great skill with battle meditation, which allows her to tilt large-scale battles in favor of either side. Needless to say, she is a much-sought-after resource for both sides of the central conflict.
Her link with the player is also important, as she could theoretically serve as a Morality Chain to turn him to either the Dark or the Light. Fortunately for a light side player, it works both ways.
The canonically-female Jedi Exile from the sequel also counts. She's a Force cypher of sorts, drawing power from others around her. She's the keystone for the Big Bad's plan to kill the Force.
Lufia has Erim, the Sinistral of Death. Her very existence enables her fellow Sinistrals to keep coming back no matter how often they're defeated; unfortunately, this isn't exactly a power she has any control over. Oh, and she usually shows up in each game as a mysterious girl... including Lufia herself in the original game.
In Silent Hill 3, the Apocalpse Maiden is the protagonist, Heather, whose memories and Reality Warper powers as Alessa are awakening and threatening to destroy the world by giving birth to the cult's twisted version of "God". The heroes consider the possibility that the only way to save the world might be to kill her; one of them simply can't bring himself to do it, while another mistakenly thinks he's found a third option that'll solve the problem. In the end, the villain saves them the trouble by gruesomely taking on the role herself, and then getting consumed by the creation an imperfect "God" that can be defeated.
In Final Fantasy XIII, generally anyone who has been branded a "Pulse l'Cie" will be given a Focus to become an Apocalypse Maiden (Ragnarok). Once branded they either have the choice of carrying out their Focus (destroy the world) or becoming a mindless monster if they refuse.
Tiki from Fire Emblem Akaneia is an immensely powerful Manakete put into an enchanted sleep, for fear that she'll destroy the world by mistake. For a time, she's Brainwashed and Crazy to work for the Dark Dragon.
In Genealogy of the Holy War we have Deirdre in the first generation, Julia and Julius in the second. They're Deirdre's children by Arvis. Deirdre had been forbidden to meet any men for fear it would cause a catastrophe. This is because she carries the blood of the dark god Loptyr, and if any child with major Loptyr blood is born they could serve as a vessel for his return—which is exactly what happens to Julius. Good thing that Julia was born with the Holy Blood needed to counteract that too..
Happens again in Fire Emblem Awakening. But not to Tiki, actually! Turns out your player-created Avatar, whether a boy or a girl, is in fact of pure enough Grima blood to serve as a vessel for his return. Worked in the Bad Future timeline, but averted in the present one. Not to mention you can recruit an adultTiki as one of the True Companions willing to help you fight against Grima. (And if your avatar's a dude, he can romance and marry her too.).
In Fire Emblem: The Sacred Stones, Prince Lyon of Grado gets possessed by the Demon King after he breaks a Sacred Stone to get at its immense magical power. The Demon King is about as nice as his title would suggest and starts trying to fully escape so he can wipe out the continent, using the unfortunate kid as a vessel.
In the Baldur's Gate series, it first appears that the Player Character him-/herself, along with all the other Bhaalspawn, is prophesied and destined to bring about not quite the End of the World as We Know It but hell of a lot of slaughter and chaos simply by existing. Eventually, it turns out that the prophecy in question actually tells about what will happen if the protagonist should fail, making them The Chosen One instead.
It's a little more complicated than that. The Bhaalspawn exist to bring back Bhaal (he sired them in response to a prophecy of his own death, which has since come true), and the current prophecy deals with the doom involved in any of the Spawn resurrecting or replacing their father. The protagonist is trying to avert this end... ''which is also discussed in the prophecy'', making them both the possible agent of the apocalypse and the potential means to avert it.
In Lunar: The Silver Star, Luna AKA The Goddess Althena nearly destroys the world after being brainwashed by the Magic Emperor.
In Lunar: Eternal Blue, this same role falls to Althena's younger sister Lucia, whose job it is to destroy Lunar to prevent Zophar's rise to power. She chooses not to. However, this allows Zophar to capture her.
Furiae in Drakengard. Her body is one of the few seals that prevent the end of the world- Thus it's her brother Caim's job to protect her. So when she dies... Hoo boy.
In FEAR, Armacham's researchers, particularly Harlan Wade, came to the conclusion that Alma Wade was perfectly capable of destroying the world with her Psychic Powers. This was one of the reasons why they sealed her away in the Vault at the age of eight. However, this only delayed the inevitable, and the efforts of Project Origin to make supersoldiers by raising them in Alma's wombonlymadethings worse.
The Dark Elf of the Mega Man Zero series. Originally created to become the cure to The Virus that caused the war in the Mega Man X series, she was later corrupted into servitude under a monster, who uses her as a way of committing genocide on the planet.
Ragna himself is apparently destined to be the "Destroyer of the World" who wields a power that even Terumi couldn't control if it was unleashed.
Elizabeth in Bioshock Infinite was to be made into this by Comstock through brutal emotional and physical torture. Comstock planned to make Elizabeth his heir so that she may reenact his version of the Final Judgment and rain fire upon the "Sodom below". However, the Elizabeth who does accomplish this brings Booker to him timeline to give her a chance to stop all of that from happening.
Booker DeWitt is a lesser version of this, after being revealed to be the "False Shepard", prophesied by Comstock to lead Elizabeth astray and bring destruction to Columbia. This is because Comstock is actually the alternate reality version of Booker himself.
Ilya too, for related yet mutually distinct reasons.
The holocaust at the end of the previous Heaven's Feel demonstrates just how much. It would've been worse if Kiritsugu hadn't destroyed Ilya's mother Irisviel.
In one of the endings in Saya no Uta, Saya blooms and gives Fuminori her final gift: the world. She does so in the expense of transforming everyone on Earth into an Eldritch Abomination, much like herself.
Gwynn from Sluggy Freelance during the period(s) when she was possessed by the demon K'Z'K.
In Homestuck, Aradia brings about the end of her world through the game. Her username for a messaging service is even apocalypseArisen.
Her last name is also Megido, a name derived from the mountain connected to the end of the world (Armegeddon is a shortened form of Har Megidon), and her title is Maid of Time.
Her ancestor's name is The Handmaid, and is world destroying Big Bad Lord English's Dragon.
More directly and on the evil side, there's Snowman, a member of the Felt whose life is tied to the life of the universe. It's actually her heart. She mostly uses this to mess with Spades Slick without him being able to fight back. Eventually he does shoot her, destroying their universe.
In the Global Guardians PBEM Universe, Esmeree is a sorceress and a member of the evil Circle of Black Thorns. She became a black magician after her mother (an oracle) produced a prophecy that said that Esmeree would become great in the knowledge of the Black Arts, and would in the fullness of time overthrow heaven and destroy the world. It hasn't happened, yet...
Conor in the Podcast Novel Shadowmagic. The prophecy ends up being true, it just refers to someone else.
A lot of people in the Whateley Universe believe Carmilla is going to be this. Right now, the protagonists are treating her as their best friend, to the point that Bladedancer is trying to find out who is trying to kill Carmilla. This could turn out really badly somewhere down the line.
In The Gamers Alliance, Leon Alcibiates becomes this when he almost manages to regain his Andain powers during the First Battle of Remonton. He realizes at that moment that as long as he exists as a revenant, his existence will eventually make magic disappear and cause the end of the world.
The SCP Foundation's SCP 231-7 is a pregnant young woman recovered along with six others and a document entitled "Seven Brides, Seven Seals" from a "satanic sex cult." The first gave birth shortly afterward; the resulting abomination killed an undisclosed number (the censor box is at least three digits) of people before being put down by Foundation personnel. Attempts to remove the fetus, or the death of the mother, had similar results in the next five but with the scale of the event and number of casualties increasing exponentially. SCP 231-7 giving birth is expected to cause a class XK End-of-the-World scenario. The containment procedures which have prevented this so far are... best left unmentioned. Other than to say that they're worse than you think they are, and have caused numerous suicides among staff despite regular psychological examinations, short tours of duty, and class A amnesiacs available on request. An Easter Egg message on the page reveals that the Foundation — or people manipulating it — doesn't want to find a better solution. They want the unborn Apocalypse right where it already is.
Raven in Teen Titans. A prophecy made at her birth pretty much guarantees that she will act as a portal to bring her demon father Trigon to Earth so he can take over the dimension, starting by bringing about the end of the world on Earth. Raven, believing there is no hope, complies, but saves her friends, who work on defeating Trigon after the world ends, shockingly enough with the help of Slade. In the end, Raven decides her father has no power over her after all, and proceeds to beat the tar out of him.
Of course, it was a Self-Fulfilling Prophecy. Raven acted as the portal to bring Trigon to Earth because she was so completely convinced she had no choice in the matter.
That, and that her friends would die in their attempt to fight off Trigon's minions...
Flame Princess from Adventure Time.Her heat increases gradually in any kind of romantic situation, and even a little thing like a kiss could do damage to the earth's crust, unleash molten lava, and instigate a second apocalypse.