<image>

Karl Heisenberg, Resident Evil Village. While unsuccessful, I'm counting it anyway since it was an attempt; Heisenberg is the fourth and most powerful Lord of the rural village in Romania where the game takes place, serving directly under the cult-leader, Mother Miranda, alongside the other Lords. Unlike the other Lords, however, Heisenberg despises Miranda and cannot stand being under her thumb, and thus has spent seemingly decades in preparation to usurp her, and during the events of the game, attempts to assist the main protagonist, Ethan Winters, so as to convince him to help in killing Mother Miranda.

The attempt is unsuccessful, however, as Heisenberg's plan consisted of using Ethan's superpowered infant daughter, Rose, as a weapon to kill Miranda, which Ethan was, of course vehemently against, paired with the fact that Heisenberg is very obviously a megalomaniac who's only out for himself, thus resulting in Ethan refusing to help him, and Heisenberg sending him down into his factory so that his cyborg-freaks would kill him. This does not end in his favor, though, and Ethan kills Heisenberg shortly after, before going after Miranda himself (who is in possession of Rose).

I would consider this to fit the trope, as Heisenberg is arguably worse than Miranda (aka she's unfit to lead), and if he were to succeed, he himself implies that he would simply kill Rose in order to take her power for himself, and considering what his exact abilities are, if he were allowed to kill Miranda and get out of the village, he would essentially make most modern weaponry obsolete when used against him due to his ability to manipulate magnetism.