Saiki Kusuo - The Disastrous Life of Saiki K: Saiki is a very powerful psychic, grown with bright pink hair. Instead of using his abilities to alter his hair colour, he decided to use his abilities to make everyone else’s hair colour vary, making his pink hair natural in the world around him

Thanos - Marvel: Thanos gets all of the infinity stones and kills half of the universes population in a bid to reduce overpopulation and the threat to necessary recourses… Y’know, instead of doubling the necessary resources and slowing overpopulation with his abilities…

Examples:

Rock Lock (My Hero Academia)

Mother Rosa ( Make the Exorcist Fall in Love)

1. Rise of the Planet of the Apes. The main character may have been the one to develop the drug that makes apes intelligent, but it was the executives who then fucked it all up and ignored his warnings, ultimately causing a pandemic that killed off most of humanity.
2. Jurassic Park/World franchise. In particular, in the first Jurassic World the park was actually doing OK until executives demanded a bigger dinosaur and the military demanded a more dangerous dinosaur.
3. The Hulk exists because General Ross and the US military wanted a Gamma bomb, and Ross actually rushed the process even though Banner wanted to be more cautious. And that's not the only time General Ross tried to create weapons that ended up endangering people.

I have noticed that in recent years instead of the old trope of the "mad scientists" being the bad guys who cause death and destruction due to their obsession with science, nowadays media tends to lay the blame on these disasters on the people in power who often ignore the advice of the scientists. I for one welcome this change, the "mad scientist" trope can sometimes feel like anti-intellectualism.

Popeye the Sailor Man (Popeye)

Franky (One Piece)

Prince Naveen in his Frog form (The Princess and the Frog)

1. Thragg (Invincible) resembles a jacked Freddie Mercury.
   
2. Howard Wolowitz (The Big Bang Theory) looks to be the lost fifth member of The Beatles.

Justice League Dark: Acropolis War
Darkseid took down most of the Justice League with only a small number alive. In order to defeat him, Superman has to work together with Lex Luthor and the Suicide Squad

Transformers Animated
The Decepticon Soundwave took down the Autobots (and mind controlled them) and so Sari has to create a makeshift team consisting of a former villain, beastly sort of villain, and wild card)

This is admittedly not super common but it nonetheless annoys me on the rare occasions I see it. There’s tons of times a character reaches out an arm while trying to do something and the direness of the situation finally lets them unlock that power. That trope is fine. But it’s so stupid looking when a character reaches out an arm without even knowing about a power’s existence and that power manifests. Like, what was their actual game plan if this new ability didn’t pop up? What were they originally thinking they’d accomplish?

1) Korra (Legend of Korra) unlocking her Airbending. Korra only had access to Earth, Fire, and Waterbending at the start of the show. She tried Airbending but repeatedly failed to unlock it. Amon has just bloodbent her brain and blocked the chi paths for her main 3 bending styles. Korra throws a punch and is confused that her body airbent. If she was actually trying to finally Airbend here, I’d have no issues. It’d be in line with the dire situation trope. But her own confusion that the punch resulted in Airbending means that she must’ve been trying any of the 3 already blocked bending styles. What were you hoping for Korra? What were you trying to bend when you know you’re chi blocked?

2) Eren (Attack on Titan) activates The Coordinate. The Coordinate has the power to control Titans but typically could only activate when someone with the power of The Founding Titan was part of the Eldian royal bloodline. Now Eren has the Founding Titan and the Titan he punches was part of the royal family during their life as a human. But Eren didn’t know either of these facts when he threw that punch. Fortunately he lucked out that the physical contact with royalty let him briefly use The Coordinate to make other Titans attack the royal Titan. But what was he trying to do without that lucky break? He just told Mikasa that he’d protect her. That he’d wrap her scarf around her as many times as needed. Yet his very next move was to fist fight a Titan. A fight he had to have known was impossible to win. Eren has always been reckless and prone to self destruction but he just vowed long term protection of Mikasa. So what was his game plan here?

3) Nero (Devil May Cry 5) unlocks his Devil Trigger. Nero is trying to stop his dad and uncle from killing each other. They’re both like a mile away at the top of a demonic tree. He’s running after them on foot and all the emotional turmoil coupled with his resolve to be better this time around unlocks his demonic powers. He grows wings made from his demon energy and regrows his arm. But… why was his arm outstretched? Who was he reaching for? He can’t see his family. They can’t see him. He’s reaching at nothing. And it’s definitely not like he intended that move to pair with his newfound flying abilities because he has to retract the arm before properly taking off. The only reason I can see for it is just a money shot of his arm regrowing. But in-universe, he has zero reason to reach out. It achieves nothing. What’re you trying to grab, Nero?

-Doofenshmirtz He's not a typical villain, but he has a generalized hatred towards the people of a city; however, he has Perry, whom he has called friend more than once.

- Gru is a villain/ex-villain, although with his pets/minions and especially with the girls he ends up showing much more affection than he lets on.

-Voldemort is extremely ruthless with virtually everyone, but Nagini is his constant companion and receives very different consideration.

Night lords(Warhammer40k)
Xiliens empire (Godzilla final wars)
The Keberos unit (Jin Roh)
Helghast empire(Killzone)

Bit of a mouthful to define this one properly - when the protagonists have to work with the enemy, be it going undercover or what have you, and there's someone who is very likable, making the fact they have to go down when the truth is revealed all the sadder.

1. Ace (Mad Max: Fury Road) - A highly competent leader who cares about his men, mourning their deaths, I've seen a not insignificant number of people, including myself, who really liked him and found it sad when he inevitably found out that Furiosa had turned away from Immortan Joe and had to be killed.
2. Alexi (Creature Commandos) - Leader of Pokolistan's Amethyst Knights, he's a big and friendly lug with a love of American pop-culture and a struggle with picking up on sarcasm, the Creature Commando who kills him, Doctor Phosphorus, laments after killing him that "I liked that guy!"

Cyclops(X-Men) - After essentially taking up the mantle to lead all of mutantkind, he made himself busy by being a teacher, leader, hero, strategist, hard-decisions guy, etc. for the X-Men and leaving almost no time for his own needs and wants. It got to the point that his mindset has been so warped by his workaholic, serious, trauma-filled personality that psychics and telepaths note how well organized and easy to read his mind is.

Rumi(K-Pop Demon Hunters) - She coerced her team(the other girls were excited for it as well but were REALLY anticipating their vacation) to start promoting their next single just after finishing a World Tour. She has reasons for it but the stress of non-stop working partly led to some of the drama they got caught up in later in the film.

Batman(DC) - Relentlessly works on stopping major crime in Gotham as well as being a leading member in the Justice League. His only major resting period is when there's a lull in Gotham crime and even then he does patrols due to how uncanny a silent Gotham is.

Sam Vimes(Discworld) - As the Commander of the Ankh-Morpork City Watch and how the world of Discworld works in tandem with common literary tropes, he is a textbook example of a cynical workaholic who never really takes a proper vacation cause trouble follows him everywhere. He has actively tried to not be a workaholic now that he has a wife and child but it's a mild success at best.

Monty Oum(IRL) - He is known to be a workaholic who has been noted to go on sleepless nights making sure his projects are as perfect as they can be. It's even been speculated that his death due to allergy was caused by poor health stemming from how he never gives himself proper rest.

Zhu Yuan(Zenless Zone Zero) - Subverted example. It's been assumed in-universe and out that she, the top cop of her precinct and major super cop, was a workaholic who does overtime and never takes vacations. But she has refuted that idea and reveals that she always leaves her job on time, never takes extra missions and takes all the vacation time she deems necessary. It arguably helped her be the super cop she is in the present since she has a healthy and energized mind and body.

Sabertooth (Marvel Comics) realizing a pissed off Deadpool is not something to fight
Wendy Corduroy (Gravity Falls) seing the Shack overrun by the special forces
Domino (Deadpool 2) seeing the Juggernaught

A situation where a plot hole becomes the reason the plot even happened.

The Martian – the heroes are forced to abandon the planet due to a powerful sandstorm that threatens to destroy the ascent module. The problem is that, due to Mars's thin atmosphere, storms on the surface of the red planet fall below the upper limit of calm on Earth. Andy Weir himself admitted that he simply couldn't come up with a different plot twist and simply used a fantastical premise.

Spider-Man: Far From Home – The film's plot would have ended rather quickly if Peter had figured out how to use E.D.I.T.H. to check Quentin Beck's file - but due to life's circumstances and some manipulation by Mysterio, Parker simply won't have the opportunity to do so, even if he wanted to.

Pirates of the Caribbean: Curse of Black Pearl — in the first film, Elizabeth threatens to throw the medallion into the ocean, giving the pirates a mini-heart attack... despite the fact that these undead creatures can easily walk on the seabed as if they were on dry land, which they beautifully demonstrate in the climax. Of course, finding it on the seabed is almost impossible, but the pirates sensed the medallion far from the island and came straight to the governor's estate, meaning they somehow knew its location after it sent a signal. The most common explanation is that the magical sense of direction is not very accurate and they have been looking for this damn medallion for decades and it's a bit nerve-wracking...

Eurotrip — the whole plot is based on the fact that someone, having been blacklisted, didn't think to write from a different account.

An important clarification: this trope has nothing to do with the quality of the story itself, and in many cases is entirely intentional and necessary. I also apologize in advance if I have conveyed any details incorrectly.

Gharkul Blackfang-warhammer 40k

Blackfang was one of the most powerful orc warlords humanity faced during great crusade. In battle of Gyros Thravian, he faced the Legions of Horus, Rogal Dorn and Mortarion and he came close to defeating all three of these legions, and they would have succeeded were it not for the intervention of the Emperor himself.

He was decapitated by emperor and his army was defeated by one thousand custodians in battle.

Ancalagon the Black, the mightiest of the dragon-host-The Silmarillion

In war of the wrath, host of the Valar came to middle earth and faced army of morgoth in war, Though the war lasted for over forty years, annihilated the Orc armies of Morgoth, even Balrogs were mostly killed and ran away. As his reign was about to end, Morgoth released Ancalagon and his dragon host, which had never before been seen. They drove back and nearly destroyed the Host of the Valar, but Eärendil arrived in his sky-ship Vingilot, along with the Eagles of Manwë led by Thorondor. They faced dragons for a day and a night, and Eärendil at last killed Ancalagon before the next sunrise.

And....thats it. These are their entire appearance and lore

1. Silo: Solo has been, well, solo for a long time. When he meets his new friend Juliette, he’s wary but still kindhearted. His good nature becomes more clear as the series goes on.

2. War for the Planet of the Apes: Bad Ape is a sweet but nervous chimpanzee who was the last of his group from a zoo that were killed by humans when they gained intelligence.

1. the GTA franchise: during development of the first GTA it wasn't supposed to be about crimes and stuff, it was supposed to be about racing with police chases involved. However, the police coding was glitched and the police cars kept crashing into cars, running over civilians, etc. The devs found this chaotic scenario funny and decided to design the franchise around it
2. the Creeper (Minecraft): this story is quite popular... Notch was trying to make a pig and got the geometry wrong, resulting in a model that's tall instead of long. He found this funny and decided to design a mob that actually has that shape.
3. whip stacking (Terraria): Whips in Terraria tag enemies and boost the damage your summons do on a tagged enemy, as well as apply unique effects. Players discovered that you can stack these by alternating multiple different whips on the same enemy, resulting in devastating damage boosts and status effect combos. This was patched out in an update, which was a bit controversial because players thought it's gone for good, but the devs redesigned it as an official part of progression, adding new accessories in the game that increase the player's total "summon tag slots" (number of whip effects one is allowed to stack)

Jojo part 4:

Yoshikage Kira is a scumbag, using his powers to discreetly murder woman to satisfy his fetish, thinks he's invincible runs into Jotaro, bleeding out and on deaths door, unaware of the power gap Kira then gets the FEAR OF GOD beaten into him to the point for the entire rest of the series his game plan is "avoid jotaro at all costs"

Dragon ball z:

Tao paipai is an elite assassin using ki, once nearly killing goku in the original dragonball, years later with cybernetic upgrades (because of goku) Tao makes a living being an unbeatable merc for hire, taking glee on picking on the small folk,

Until one day in the week before the cell games he runs into a familiar brat, upon learning this is goku's son he gets the fuck out of dodge telling his boss he quits

Spider-Man Brand New Day : Naruto and Solo Leveling poster

JoJo Battle Tendency : Joseph is reading DC comic's SuperMan

Spider-Man (2002) : SuperMan exists as a fictional character

JoJo Stone Ocean : Raimi-verse Spider-Man made a cameo, this was changed in the anime and spidey is replaced by BatMan

Zom 100 : Spider-Man got mentioned in the show

The Walking Dead : Carl is reading Invincible comic

Peacemaker (DC) : Vigilante references the Spider-Man meme

Sonic The Hedgehog 3 : Knuckles made fun of Tails because Tails look like Detective Pikachu

It's called "Grapeshot" because when the rounds are together, they resemble a cluster of grapes. Because of this name, you get literal grapes being used as ammunition

1. Monkey Buccaneer (Bloons: Tower Defense 6) - Fires grapes with the Grapeshot upgrade
2. Grapeshot (Plants vs Zombie 2) - It explodes and launches a bunch of grapes hitting the zombies.
3. Hero: 108 - They eat grapes and then spit them out like projectiles.
4. Kamen Rider Ryugen (Kamen Rider Gaim) - Ok this one might be a stretch because he doesn't shoot real grapes, just purple energy projectiles. I just included him because he's a grape-themed Rider who uses a gun.

Characters frozen in time for many, many years

Transformers One, Narnia, Warframe

John Constantine: pretty miserable, sees the worst in people and is just pretty cynical, but still goes through shit to save the world.

Silver Surfer: Stretching misanthrope a bit since he does see the good In humanity, but he's very often disappointed by humanity and it's bullshit vices.

John Wick: the entire first movie only happens because they killed the titular characters dog.

Marley (attack on titan): after spending centuries discriminating against the Eldians, turning them into mindless titans and even getting the rest of the world to assist Marley in the invasion of Paradis Eren uses the powers of the founding Titan to start the Rumbling to not only destroy Marley but also the rest of the world

Kyoshi's extreme longevity (The Last Airbender): In episode 4 of ATLA, it's mentioned that Avatar Kyoshi had been born 400 years ago, but when you do the math you realize the writers only went with a big number without thinking too much about it. Aang was 112 due to having been frozen in ice, and Roku lived for 70 years. That meant that Kyoshi had to have lived for over 200 years.

Rather than retconning this, the novel The Rise of Kyoshi explained that she had learned a technique to achieve immortality from a man called Lao Ge, who was over 4000 years old himself. They even worked this into Kyoshi's ruthless reputation, as the longer she lived, the more expendable a single human life looked to her, meaning she was more willing to sacrifice people for the greater good. She also lived long enough that she started to see the long term negative effects of her own actions as Avatar earlier in life. While it is unknown how she died, most fans believe that she eventually realized living so long was interfering with her duty as the Avatar so she decided to voluntarely stop using the technique and pass away at 230 years old.

Rick's survival (The Walking Dead): At the beginning of the story, Rick wakes up after being in a coma for a bit over a month to find out that the world had been taken over by zombies. This is a cool premise, until you realize that a person in a coma would probably have died in this situation with nobody to take care of them.

Well, in the web miniseries The Oath, it's revealed that a doctor called Gale Macones, who worked at the hospital where Rick was, stayed behind to take care of her patients. She is gone by the time Rick wakes up, but it was her care that kept him alive.

The Death Star's huge weakness (Star Wars): Star Wars has a lot of these, but this one is probably the most well known. In A New Hope, the rebels get the Death Star plans and realize it has a huge weakness in the form of a small thermal vent that led directly to the main reactor. Later, Luke uses his X-Wing to shoot through this vent, destroying the whole space station. While this is a cool scene, one is left to wonder why the Empire would design their ultimate weapon with such a big weakness that allowed any pilot with good aim to destroy the entire thing.

In Rogue One, we find out that Galen Erso, the main engineer behind the Death Star's reactor, had been tricked into thinking he was working on a project to provide limitless energy to the citizens of the Empire. When he realized it was to power a weapon, he tried to escape but was forced to complete the project. He then decided to sneak a weakness into the design with the hope that the rebellion would be able to use it to destroy it.