Sailor Moon has both aversions of this and examples of it. It's averted by the benevolent Queen Serenity (no husband seen) and Neo Queen Serenity (husband seen but she appears to be in charge), the straight examples of the trope are Queen Metallia and her dragon Queen Beryl of the Dark Kingdom, and by Queen Nehellenia of the Dead Moon.
It's arguable whether or not any of the other Sailors (there as many Sailor Senshi as there are celestial bodies for them to come from) besides the ten that the story focuses on are royalty, but virtually all the royalty that is named is female (the only exceptions are Endymion and Prince Diamond)— there could be hordes of good queens out there that we'd never know about.
And conversely, it's not clear that Queen Metallia really counts as a queen. She's just called that because... well, the Dark Kingdom is called a kingdom. Queen Beryl doesn't truly count either, as she was an oracle in her past life.
Later on in the series, it's mentioned that Kei has had three of these in a row- four if you count a female pretender to the throne. There are some people in Kei who are so used to this trope that they distrust Yoko as "just another lady-king". However, Yoko herself is an aversion, as are the queens of Kyou and Sai. A character even mentions that, after two excellent (and therefore long-lived) female rulers, the people of Kyou "pray that their next ruler will not be a man."
In the backstory, there's also the former queen of Hou, Kaka (yes, we know). While the king, Chuutatsu, was bad enough, believing that execution was a fitting punishment foranycrime, the queen put this to her advantage, accusing maids and courtiers of whom she was jealous of petty crimes so that they would be killed. For this she and her husband were both beheaded in a citizen revolt.
The Queen Consort from Berserkjoins a plot to assassinate rising star Griffith after Griffith had Guts assassinate her lover.
And her step daughter Charlotte would have been a good Queen... Too bad the nation got invaded by Kushan on her first day, and then things went downhill. Charlotte recently married the love of her life, Griffith. Looks like he finally got his kingdom.
In Dai Mahou Touge, the queen of Magical Land is ruthless, domineering and just plain evil. Her daughter Punie, also known as the heroine of the series, is following in her tracks.
Maestro Delphine of Last Exile, in all but name. Sadistic, Finger Lickin' Evil and then some. On the other hand when Sophia, who was First Officer on the Sylvana becomes Empress, she's got the hallmarks of a good ruler, though she had the princess thing going for her.
Queen Himiko in the Dawn arc of Phoenix is portrayed as an insane tyrant whose only goal in life is to find the Phoenix and gain immortality.
In Kiyudzuki Satoko's manga Shoulder A Coffin Kuro, one of the short stories in the second volume features an incredibly spoiled princess who orders travelers to expand upon her favorite storyteller's fairytale featuring her. If she doesn't like where the story goes, she orders the traveler's beheading. However, this is eventually subverted when Kuro and the twins' story brings her to her senses, and her courtiers reveal that they've been using the guillotine to chop up pumpkins to fool her and let the travelers escape.
Queen of MÄR is this, as well as Snow's Evil Stepmother and Dorothy's sister. King is there as well, but he's evil also and he didn't participate in the first war. Snow's father is supposedly trapped or something.
Crown: The heroine may be the rightful heir to the country of Regalia. Unfortunately, the current incumbent is one of these, and she's proactive about eliminating the competition.
In Ouran High School Host Club, there is a story wherein the Host Club acts out Alice in Wonderland... And Kyouya is the queen. God save us all.
Actually he is the caterpillar, Haruhi's mother is actually the queen
In Miyuki-chan in Wonderland,Miyuki meets up in her dream with a (feared and in the same light idolized by her subjects) Dominatrix queen who rules over her queendom with an iron whip, which she invariably tries to use on Miyuki. who then wakes up
Interestingly played with in the Mai-HiME manga, where the Big Bad summons 3 girls called QUEENs. One of whom is his sister Mai, one of the main protagonists, who are evil and more powerful HiMEs.
Averted by Houki from Fushigi Yuugi, who started as a kind Hot Consort and after the death of her husband Hotohori was a rather good regnant Empress for the sake of the heir, their son Boushin aka the soon-to-be Emperor Reizeitei.
Done full on with the Queen of Shaluda in Knight Princess (Not the same manga as Princess Knight). She ordered the first prince to be tried for treason on trumped up charges and killed an entire tribe of secret guards for fear they would harm her son, the second prince. But averted with Yaxi's mother, Queen Weisha. She just has to deal with power hungry adviser.
Queen Iono from Iono the Fanatics. She's a nice enough person, but she's really bad for the country.
The Dream Queen, from Alpha Flight. Think sort of a combination of The Joker and Freddy Krueger; her father was Nightmare.
The entire plot of Outlaws of Gor was subduing the one dominant female character, the queen.
Which sums up Gor's main theme about how all women should know their place, and that place is being slaves to men.
But in the books, free women outnumber slave by about forty to one, canonically, and Outlaw ends up with a queen on the throne of the city of Tharna after all, albeit a thoroughly reformed queen and a heavily revised society.
Especially compared to backstory about Amidala's predecessor.
In The Lord of the Rings Galadriel is most definitely The High Queen and a good gal, but she refuses to go by that title; or even be acknowledged as the ruler of Lórien. The reason she refuses royal titles is because she and her husband feel that Lórien is merely a place they are guarding, not ruling.
The only moment when she does call herself a Queen is the moment of her temptation by the Ring. She resists it when she realizes she'll become one of these.
In Ran, King Hidetora thought it was a good idea to kill the father of his sons wife Kaede and make his new home in the newly conquered castle. Years later the King is thrown out of his home and his throne taken over by his son, making his wife the new Lady of her families old castle. May the Gods have mercy on the kingdom.
Queen Ravenna in Snow White and the Huntsman, a thorougly psychotic Smug Snake who murdered her way to the throne and steals the youth and beauty from younger women so that she might stay young and pretty forever.
Queen Eleanor of Aquitaine in The Lion in Winter from the point of view of her husband Henry II and at least some of their sons.
Several sovereigns in Tales Of The Branion Realm, particularly Melesandra III who terrifies her son and heir and has orchestrated more than a few massacres of her enemies.
The Queens of the Winter and Summer Courts, from The Dresden Files. Mab is more clearly evil, but Titania's pretty damn vicious when she wants to be. And let's not get started on the Ladies....
Mercedes Lackey generally averts this, but she plays it straight in her book The Black Swan, in which the evil queen Clothilde used a love potion on the king to gain her position, encouraged him in dangerous hobbies until he offed himself, kept her son completely unfit to rule, and plots to distract or, if necessary, kill her son in order to keep the throne when his 18th birthday (and thus the end of her regency) is on the horizon. Unusually for this trope, she's a good ruler otherwise; Lackey even gives her at least one Pet the Dog moment.
Queen Cassiopeia in One Good Knight is a dead-straight example, up to and including causing horrific storms and shipwrecks to increase her wealth. Her daughter is horrified when she realizes that is going on.
The bloodthirsty Queen of Hearts from Alice in Wonderland. It may be a coincidence, but Tenniel's illustrations of her make her look more like the traditional Queen of Spades, a card in a suit associated with death. Perhaps taking this trope even further, in contrast to her the King of Hearts is a sympathetic character, who pardons everyone who's been sentenced. Not so much in the films though.
In the Star Trek Novel Verse, the Ruling Queen, T'Rehu - Romulus' first and only dictator. The trope is perhaps particularly appropriate here, because while it's never made explicit, there is the possible implied suggestion that Romulans fear single female rulers more than male ones - simply because of T'Rehu. Both sexes serve in government and in the senate, in more or less equal numbers, yet interestingly the praetor is usually male. Possibly female senators find it harder to ascend to the position due to a bias connected with this trope. This is likely only subconscious - there are no actual legal restrictions and we do see some female praetors, but the disparity is interesting in a culture that otherwise demonstrates equivalence between genders at all levels of government. See in particular Star Trek Vulcans Soul.
Cersei Lannister, in A Song of Ice and Fire, is a cruel and paranoid despot who isn't quite as cunning as she believes she is. She quickly alienates her strongest allies and turns her kingdom into "a feast for crows." By the end of the first book, she's murdered her incompetent but well-meaning husband, and she goes on to become regentfor her belovedsons. Some readers see Daenerys Targaryen as another example, due to her perceived arrogance and penchant for brutal conquest. Worse, while both women are pretty blind to their own faults, Cersei at least recognizes the brutality of her own tactics, while Dany sees herself as a fair and just savior. If she's not this trope yet, she may yet head that way.
Very few male rulers act as sociopathic as Cersei, though, and she's the only queen at the beginning of the series. So the male average is still far more positive.
Tywin Lannister is far more evil than Cersei, precisely because he's no sociopath. He uses psychopaths such as Gregor Clegane or Amory Lorch on purpose. Cersei is, however, following in Daddy's footsteps. And there are very good examples of reigning women. Lady Olenna Tyrell is far from psychopathic; ruthless and cynical, yes, but fundamentally decent.
Fortunately, Cersei starts to run herself into the ground the second the checks on her power are removed and, three books later, has been arrested for treason, adultery, and incest by the very Church Militantshe resurrected. Nice going, Cersei.
The Queen of the Elves in the Discworld novel Lords and Ladies. Subverted somewhat in that the King of the Elves, with whom she doesn't get along too well, actually has the same goals — he's just more patient than she, or possibly smarter, and therefore approaches them differently.
Lady Felmet from the earlier novel Wyrd Sisters ought to qualify as well; she actually secures her position as queen by having her frail-minded husband Duke Felmet murder the King of Lancre, then proceeds to rule the kingdom with an iron fist from behind her husband (since the character is a parody of Lady Macbeth (See Theater, below), this is hardly surprising).
Lilith Weatherwax, who rules over Genua in Witches Abroad with an iron fist and makes sure that Happiness Is Mandatory. Anyone who isn't smiling and quiet, or doesn't abide by typical story archetypes, are fed to stories.
Queen Arrabel from Tanya Huff's "A Woman's Work" is highly competent, beloved by her people, treats her staff well... and is utterly ruthless to her enemies (and her friends, if she had any). She's the type of person who wears understated, sensible clothing while her son wears flashy, extravagant uniforms because she knows who assassins would instinctively aim at. And then she marries him off to a neighbouring country's princess (sole survivor of the royal family), the Queen expecting that the princess will quickly produce an heir, following which the prince is likely to have a fatal accident. Not that she minds, as she thinks the princess has the right stuff to inherit the job of Queen.
In The Magician's Nephew, Jadis (who later becomes the White Witch) is the Queen of the most powerful nation in her world, so what does she do when her sister attempts to overthrow her? She uses her magic to killevery other living being on the planet, then sits around waiting for someone to take her to another world so she can presumably do it all over again. Harsh. Even more blatant when you consider that she is the Satan to Aslan's Golden Feline Jesus. And while it was mentioned that while Aravis and Shasta/King Cor quarreled quite a lot after they were married, the fact that the kingdom remained prosperous for so long would indicate that she was a subversion as well.
The Lady of the Green Kirtle from The Silver Chair is sometimes called the Queen of Underland, though given how her "subjects" were basically gnomes that she kidnapped, brainwashed, and enslaved and her "kingdom" was more or less a palace under the ground, it's uncertain how certifiable her claims for the title are. Still, she would have become that had her plan succeeded.
In the Tamír Trilogy, Queen Agnalain of Skala fit this trope, since she became so paranoid she was about to have her son and baby daughter executed for treason (after having numerous others killed), but she's treated as an aberration in a long line of warrior queens and her son killing her in self-defense and then taking the throne instead of his sister is presented as even worse, since the god in charge only approves of female rulers. Up to you whether this is an aversion or a straight example.
She was called Victoria, because she had beaten us in battle, seven hundred years before, and she was called Gloriana, because she was glorious, and she was called the Queen, because the human mouth was not shaped to say her true name.
Played with in Fred Saberhagen's Swords and Lost Swords series. Even though Kristin's father held the title of King, Kristin rules Tasavalta as Princess Regnant, not as Queen. Yambu, of course, holds the title of Queen, and is a bad guy, but abdicates her throne after she does a Heel Face Turn.
The Dark Queen in Connor Kostick's Saga. With a title like that, how could she be otherwise?
Subversion: Queen Hemlock from Robert Asprin's Myth Adventures series is rumored to be greedy, ambitious, and cut-throat (literally; rumors abound that she murdered her parents to gain the throne). When we finally meet her, she is ambitious...but is also very down-to-earth and cunning, immediately seeing through the disguise that Skeeve is using to impersonate the king. And then she says that she'd rather marry a powerful magician than a king anyway.
Late in the book, Skeeve tricks Hemlock into marrying King Roderick by giving them magic rings which he claims link their lives together; if one of them dies, they both do. Much later in the series, Skeeve receives a package from Hemlock...a severed feminine finger, ring intact, leading him to assume that Hemlock cut off her own finger just to escape the magic, then killed Roderick. In the end, it's revealed that Roderick died of illness, at which point Hemlock realized the deception; the finger was his, not hers, and overall she wasn't upset with Skeeve for the trick.
Invoked, sort of, in Robin Hobb's Farseer and Tawny Man trilogies, where during the time between them, Kettricken has been a fair, just, and intelligent queen overseeing a time of much-needed peace for the Six Duchies... But because she's a foreigner who was married for political reasons, and her husband is dead, her political enemies love to spread these kinds of rumors about her.
Queen Desire, who was queen at the beginning of the first book, is a decidedly unpleasant if minor character. Kettricken escapes being evil through the "princess first" clause, as she doesn't marry a king till the very end of Assassin's Apprentice.
Mostly averted in The Wheel of Time: there are many female rulers, some of them bad, some of them good, just as the male rulers. Actually, there are more good female rulers than good male rulers — women: Morgase, Elayne, Siuan, Berelain, Alliandre (arguably), men... err... Rand and the Aiel clan chiefs. It has never been implied that when a female ruler sucks, it is because of her gender. Not even with the Seanchan empresses: while Fortuona's decision to attack the White Tower in Book 12 bordered on Moral Event Horizon, it had more to do with her culture. Many of the Aes Sedai (such as Elaida, especially after becoming Amyrlin), while not ?queens,? do seem to conform to this trope, though.
The one brief time during which Andor had a king was not a great experience. First of all, the said king was an Evil Sorcerer.
Tamora Pierce both subverts this and plays it straight: Queen Thayet of Tortall is a progressive, level headed queen who's perfectly willing to get her hands dirty (and destroy expensive dresses (and her modesty (see the howler monkey incident)) in the process). Princess Imajane Jimajen, the regent of the Copper Isles in Trickster's Queen is ruthless, mentally unstable, and arranges the murders of the six-year-old King Dunevon and his similarly aged heir Elsren, so she can take the throne. Her successor, Dove, is implied to be another subversion of this trope.
Two queens in Karen Miller's Godspeaker Trilogy. The first book is about a nameless brat who rises to Mother of the Heir via slavery and soldiery with divine guidance. Her ambition is to use her son as a 'Hammer' to take over the world. The second book is about a Princess whose father and two brothers die, and she must fight to become Queen in her own right. 3rd book, both queens get to duke it out.
Queen Elizabeth III of Manticore in the Honor Harrington novels is very much the good constitutional monarch, justly admired by most of the population (even those who have issues with the rest of the aristocracy), except that she has a ferocious temper and is said to hold grudges so long she has them stuffed and mounted. When it comes to the People's Republic of Haven, she could be totally unreasonable and would be quite happy to see them all shoved into a black hole, what with that aforementioned anger issue and them having assassinated her father and all...
Eloise Pritchart, the President of the restored Republic of Haven from the tenth book on, is very much Elizabeth's counterpart. She's a brilliant, enormously capable leader, well-loved by most of her people, but her fiery temper, combined with some subtle manipulations by a mutual enemy of the Star Kingdom and the Republic, leads to a totally unnecessary and tragic resumption of hostilities between the two star nations, culminating in the near-total destruction of both their navies at the cataclysmic Battle of Manticore... just when their real enemy is about to unleash its campaign of conquest on all of human-settled space.
As of Mission of Honor, the twelfth book, both have been informed of said mutual enemy and have formed a military alliance. What's worse than facing one hardcore determinator Queen with a badass military that's been hardened and trained in the crucible of decades of war? Facing two.
Arthur's sister, Morgan, is married to King Uriens in Twain's A Connecticut Yankee In King Arthurs Court. She kills a young servant for bowing too low and accidentally touching her knee. She continues to entertain her guests as the servants clean up the mess left after she stabs the boy.
Death isn't the only Disproportionate Retribution she deals out. When a peasant slights her, she takes him from his wife and five children and locks him up in her dungeon for twenty-two years, giving him a view of his house from his cell. She then orchestrates five fake funerals at intervals, leaving him to agonize over which of his family still lives. His crime? Saying she had red hair.
Queen Lionstone, in Simon R. Green's Deathstalker series, fits the trope quite nicely. She's even set up a holographic 'playground' of a throne room which has claimed quite a number of courtiers, just for her own amusement.
David Eddings' Belgariad/Malloreon brings us Queen Salmissira of Nyissa, the craziest and most dangerous person in her whole country of drug-addicted snake worshippers. At the end of her first appearance she is turned into a giant, immortal, highly venomous snake, which markedly improves her personality and her governance of the country.
The Queen of Attolia in Megan Whalen Turner's The Queen's Thief series is played almost-straight in book 1, then averted completely in following books. It's gradually revealed that although she rules with an iron fist, the conditions of her monarchy demand fair but stringent behaviour to maintain power and security.
That Eddis doesn't need to resort to such tactics to keep her throne has bred resentment in Attolia.
Attolia has a particularly bloodthirsty grudge against the protagonist Gen that tellingly exceeds her normally fair and politic judgement.
And then she goes and marries him anyway. Go figure.
L. Frank Baum's Oz was founded by a Fae Queen, who is revered through most of the land, and her descendant Ozma is just and reasonable ruler, as are the Good Witch of the North and Glinda, but you get plenty of rotten apples such as the East and West Witches, Princess Langwidere, Jinjur, and Coo-eh-oh.
In The Looking Glass Wars series, the main antagonist is a woman named Redd, who believes that she was robbed of her right to the throne even though it was for the perfectly logical reason of her reckless, uncaring attitude. When she finally takes over, Wonderland becomes a place where people are encouraged to spy on their neighbours, among other more evil actions.
The queen in Robin McKinley's Deerskin is universally beloved until she starts dying (of her own will, because she feels she's suddenly not the World's Most Beautiful Woman). Everyone but her husband very quickly winds up completely terrified of her, regarding her almost like she's some kind of witch. The really terrible consequences of what she does don't happen until several years after she's dead, though.
From Gail Carson Levine is Fairest's Queen Ivi, a foreigner who disbands the country's parliament, imprisons people for minor slights, obsessively seeks approval, and would have probably started killing people if Aza hadn't saved the day.
In The Once and Future King, Queen Morgause is empty-headed at best and downright treacherous at worst. She enchants and sleeps with Arthur for a grudge held between their deceased parents, completely ignores her children who worship the ground she walks on, (unsuccessfully) attempts to seduce Sirs Grummor and Palomides and King Pellinor, and eventually seduces King Pellinor's much-younger son, which leads to her death when her sons find her in bed with him. Her first appearance is killing a cat in a boiling pot of water and putting the bones in her mouth, just because she's bored and wants to try an invisibility spell. On the other hand, while Guinevere inadvertently screws up Camelot, she still is a good person who cares about her husband and tries her hardest to defy Mordred at the end of the book. The daughter of the Queen of Flanders presumably also subverts this trope (after she marries King Pellinor of course), since the two are completely in love with each other and she is remembered fondly by all after her death.
Averted by Mara of the Akoma. Just minutes away from taking orders at a convent, she becomes the lord of a greatly diminished house upon the deaths of her father and brother. For the next three novels, she plays Xanatos Speed Chess with everyone in the empire just to stay alive.
In Anne Rice's Queen of the Damned, the titular queen, Akasha, is the first vampire. Back when she was the queen of Kemet (Anient Egypt), she instituted harsh reforms on the people simply because she didn't like certain customs, like eating the dead by their loved ones (she didn't see a difference between honouring the dead this way and cannibalism). She then has her troops kidnap the witch sisters Maharet and Mekare just to see what they're all about. The troops slaughter anyone in their way. After she doesn't like their display of ghosts, she has them publicly raped by a servant and sent home on foot. Her tyrannical rule eventually causes her own subjects to fatally wound her. This allows a bloodthirsty spirit to inhabit her body, turning her into a vampire. This doesn't improve her disposition. Then she has the witches kidnapped again. After she doesn't like their explanation of her new existence, she has one blinded and the other one to have her tongue cut out. She then forcibly turns the same loyal servant, who turns the witches and tries to build an army to fight the queen. She catches them, puts them into coffins and sends them to the opposite corners of the world. The twins wouldn't see each other again until modern times. After waking, she proceeds to slaughter most of her progeny and has human women murder any man they see in order to create an all-female paradise. Her last act is to demand the remaining vampires to join her or die. Luckily, she gets Karmic Justice.
In the Emberverse, Queen Hallgerda manipulated her husband Mad King Charles, placed her stepsons Princes William and Harry in harm's way in the hope that they would be killed, and finally murdered Charles when he refused to disinherit Wills and Harry in favor of her own children by him. She also murdered or imprisoned anyone she perceived as a threat to her power.
In the Vanity Publishing children's fantasy Lundon's Bridge and the Three Keys, jellyfish Queen Darlina is described as "the best of the best" queens of the ocean, BUT as the story begins an advisor brings her the news that husband and daughter have been killed in the Decayed Sea that humanity's pollution has created. She vows revenge on humans, imprisons subjects who object to her plan, and kidnaps a human scientist (the heroine's dad) to steal his body so she can take human form. From there she orchestrates the kidnapping and brainwashing of human children, turning them into half-insect creatures to destroy their world as humans destroyed hers. As it turns out, the king and princess aren't dead — the evil advisor kidnapped them, intending to take over the kingdom once her plans were carried out. When they are reunited, she frees/restores all her victims and is forgiven.
The Black Papess in The Orphan's Tales. Granted she's justified in wanting revenge after she was used as a political pawn and punished for it, but she more or less wants to tear down Al-a-Nur from the inside centuries later when the current residents have done nothing to her.
Arpazia, the resident wicked queen of the Snow White retelling White as Snow.
The Three Musketeers has Anne of Austria, who's neglect and pettiness after the death of Richelieu nearly caused the nation of France to implode in civil war and bankruptcy.
A more straight example of the trope occurs in Alexandre Dumas's La Reine Margot with the French dowager queen Catherine de' Medici. This novel was also adapted into movies twice.
Queen Elizabeth II and the entire Royal Family are some sort of reptilian overlords according to the published conspiracy theories of David Icke.
Queenie in Blackadder II is a ludicrously exaggerated version of Elizabeth I, using the extremes of anti-Elizabethan propaganda to produce a Psychopathic Womanchild who orders executions on a whim. Miranda Richardson went on to play Queen Mab and the Queen of Hearts. (Given the portrayal of male monarchs in Blackadder, though, this probably isn't sexism as much as Aristocrats Are Evil.)
Especially if you tell her that you killed her boyfriend.
There's a reason why many fans refer to her as Madame Airlock.
Averted in The 10th Kingdom. A "Golden Age" is referred to several times in which the nine kingdoms prospered under the rule of their queens, but played straight later on with Virginia's mom
Mercy Hartigan in the Doctor Who Christmas Special "The Next Doctor".
Two Christmas Specials before that, the Queen of the Racnoss.
Averted with Elizabeth the Tenth in "The Beast Below". When we meet her, she's a rebel in her own country, trying to find out the dark secret it's hiding. Turns out it's that Starship UK is built on the back of a star whale, who's being tortured to ferry them across space...and every ten years she has her memory erased so she forgets that she gave the order to do so. What averts this though is this is a case of Utopia Justifies the Means, and when Amy gets her to "abdicate", it turns out the star whale is doing this willingly.
In Tin Man, the heroes are on the run from the Sorceress-Queen Azkedelia, who seems (at first blush) analogous to the Wicked Witch of the West and certainly has the attitude to match. However, like everything else in this version of Oz, things aren't exactly as they seem. For one, she's a descendant of Dorothy Gale, just like her sister, DG. Second, she's not exactly doing the driving. There's also the "good" lavender-eyed Queen who is being held prisoner.
The Evil Queen/Regina Mills in ABC's Once Upon a Time. She's trapped every known fairy tale character in a dead-end town in Maine and made herself mayor so she can control their lives. Anyone who stands up to her ends up miserable or dead.
Her mother, the Queen of Hearts is far worse.
Bal-Sagoth worked this into musical form in their song "To Dethrone the Witch-Queen of Mytos K'unn (The Legend of the Battle of Blackhelm Vale)" on their album Starfire Burning Upon the Ice-Veiled Throne of Ultima Thule. In brief, a witch queen of a powerful empire sends her army of questionable humanity to invade her neighbors, until said army is met in battle by heroic barbarians in the titular battle. Yes, this is all described in lyrical detail - and further elaborated on in the lyric book itself.
To be expected, really, as said Queen is a faerie queen not unlike Mab and Titania.
The 14-year-old queen in the Vocaloid song "Daughter of Evil" killed an entire kingdom of people because her crush loved one of its citizens and not her. Played with in that you actually feel sorry for the Queen later in "Regret Message" where she's shown to have been spoiled Jerk with a Heart of Gold who didn't understand the pain of losing someone.
Then there's the sordid tale of Conchita, The Epicurean Daughter of Evil. Suffice to say that this tale plays the trope completely straight.
Jezebel, the wife of King Ahab (who himself was weak-willed and something of a spoiled brat).
Queen Athaliah, who tried to murder the entire house of Judah so her sons could take the throne. She missed one.
The Bible in general didn't have nice things to say about kings who 1) married foreign wives and 2) succumbed to worshipping said wives' foreign gods.
In the New Testament, when Herod Antipas asks his unnamed stepdaughter (Christian tradition and some historical evidence indicates it as "Salome," and she was also his niece) to name any reward ("up to half his kingdom") for her dancing, her mother suggests "John The Baptist'sHead on a Platter", thus trope-naming a popular expression. In both cases it's claimed that Herod Antipas enjoys John's preaching and is only forced to have him killed because he gave his word to a treacherous woman.
Wouldn't that make her an evil princess? In fact, Jezebel and Athaliah were partially justified in being evil queens: they started out as evil princesses.
There are good queens, though: such as Bathsheba, Esther, and the Virgin Mary (she is the Queen of Heaven in Catholicism; the Book of Revelation does have the mother of the Messiah be exalted in Heaven). As noted above, it tends to be that the poor girls who are awarded the title tend to be good, the ones who were born royalty tend to be evil.
Vashti, possibly. The Book of Esther only says that she refused to appear before her husband when he demanded it, and was put to death as punishment. This alone makes her sympathetic or even proto-feminist, though Jewish tradition paints her as a tyrant who abused her Jewish servants. In this version her refusal to appear before the king was because the Archangel Gabriel punished her with some kind of disfigurement.
Many villains in classic tales like "Snow White" and their Disney adaptations.
Guinevere cheated on Arthur with Lancelot, leading indirectly to his defeat at the hands of Mordred.
And that's the modern, sympathetic version! Older, Welsh versions had it that she cheated on him with Mordred and actively betrayed him. (In some regions of Wales, "Guinevere" is a euphemism for whore.)
Geoffrey Chaucer either plays this straight or averts this in "The Wife of Bath's Tale," depending on whether your sympathies lie with the knight whose life she saved (and whom King Arthur would rather have executed), or with the women he could potentially rape.
The Unseelie Queen Mab/Maeve/Queen of Air and Darkness is almost always portrayed as evil, even though a lot of the same books that mention her also mention that the Faerie don't think of good and evil the same way humans do. She's nasty by any standard, apparently. And the Seelie queen is usually portrayed as good...ish.
This is cited as the "moral" of the Ulster Cycle story Táin Bó Cúailnge, or The Cattle Raid of Cooley, where Queen Medb, eager to prove an arrogant boast that she is equal to her husband, touches off a terribly destructive war in an attempt to acquire a bull the equal of the best of his.
Hera from Classical Mythology in any story about Zeus's affairs. She even scares him at times, but cannot do much so she takes her rage out on his lovers. A perceived insult can result in harsh punishment. She aided in the destruction of Troy because she lost a beauty contest. Many modern adaptations of portray Hera as having gone insane from jealousy. Zeus is needed to restrain her. The more sympathetic portrayals have her as someone easily angered and not to cross lightly.
Chess. There is only one Queen, and she is the most powerful piece. She effectively serves as The Dragon for the King, being able to move as many spaces as she wants, in whatever direction she wants. Only the Knight can attack the Queen without directly risking itself and, worst of all, any Pawn that reaches the other side of the board can become another Queen.
Exalted's Scarlet Empress. Ruthless, rules over The Empire, sends her minions on a seek-and-destroy mission to hunt down new PCs, keeps her subordinates backstabbing each other to maintain her own power...on the other hand, she did save the entire world from obliteration by The Fair Folk in the backstory, and is currently being held prisoner by The Legions of Hell.
Then comes Return of the Scarlet Empress. You thought she was bad before? Now she's the Ebon Dragon's sweet baboo/hand puppet.
The Queen of Aundair in Eberron is like this. She's convinced it's her destiny to rule the entire world. Since she lacks the military power to pull it off, she's mostly scheming. She's got no problem with starting another world war, as long as she knows she'll come on top. The funny thing? The rules say she's Neutral Good. Compare the King of Karnath, a Vampire who pulled off a My Grandson Myself combined with a Man In The Iron Mask to for the sole goal to save his country from ruin and famine, free it from the clutches of an evil church, fight a terrorist organization AND is one of the major architect of the continent-wide peace treaty that ended the century-long world war. His alignment? Lawful Evil. Word Of God on this matter says that Aurala is a genuinely nice and decent person, but was raised to have an outdated, culturally myopic view of seeing war as the "game of generals", naively believing that resuming the Last War won't be so bad. King Kaius, on the other hand, knows just how utterly naive this viewpoint is, and while he is incredibly selfish and amoral, he's also quite honorable and actually gives a shit about his general image. In other words, Aurala is Naive Good and Kaius is Pragmatic Evil
In the Tormenta (D&D setting), the Fairy Queen Thanthalla-Dhaedelin is depicted as a vain, frivolous, omnipotent Cloudcuckoo Lander. Because your left canine is one tenth of a millimeter shorter than the others, she may simply wish you'll from now on work as a dung scavenger, and it WILL happen. The last one involved changing the calendar so her estimate would remain right.
In both Vampire The Masquerade and Vampire: The Requiem, "Prince" is the title given to the most important figure of the Vampire politics. The title can vary and some vampires may call themselves Sultans, Dons or even Presidents, yet most of them would humbly avoid being called "Kings", but the same cannot be said to some self-proclaimed "Queens".
There are many female leaders in BattleTech who fall under this trope, but the two best examples are probably Romano Liao, the paranoid and insane former ruler of the Capellan Confederation known for her tendency to order the violent deaths of her citizens, often for no discernible reason, and Kathrine Steiner-Davion, who had her own mother assassinated then manipulated control of the Federated Commonwealth away from her brother before her tendency towards hamfisted control caused a civil war to break out.
Warhammer Fantasy has Dark the Dark elves hag Queen, Morathi, is one of the most powerful wizards in the game and the reason the dark elves had been corrupted in the first place. The Hag Queens of the Temple of Khaine are berzerkers that go to battle looking like they are two thosand years old by human standards and wearing next to nothing. If that isn't frightening, nothing is.
Likewise, LadyMacbeth qualifies after she manipulates her husband into killing King Duncan and taking the throne.
And Queen Margaret in Henry VI Parts II and III is something of a harridan, keeping the Wars of the Roses alight long after everyone else would far rather just give up and go home. She's a bit more of a shrinking violet in the Prequel, Part I.
She apparently is also a bit of an evil foreigner, called the "she-wolf of France".
Queen Titania of A Midsummer Night's Dream isn't really evil, but spends most of the play bickering with her husband over a changeling boy in her care. Of course, Oberon isn't much better and responds by having hermagically enchanted into lovinga man with a donkey's head until she gives him the kid (and even then, mentions that he only is having her freed because he pities her). So yeah, the play seems to come off less as "queens are evil" than "fairies are jerks".
And if her plan had succeeded, probably Roodaka would have become something similar — but with the official title of a queen.
Queen Brahne from Final Fantasy IX: no king in sight, though it's hinted that he died of (presumably) natural causes sometime in the past.
It's presumed he died before Brahne met Kuja and subsequently turned evil, so it's unlikely she was responsible. Remember, Garnet says she was really kind before previously spoilered event.
Final Fantasy VIII has a number of sorceresses which play the role of evil queens. Edea becomes ruler of Galbadia, Adel was once the ruler of Esthar and Ultimecia is the sorceress who is the puppetmaster of them both.
Queen Asheviere from Battle for Wesnoth: has the prince murder the king during a war. Said prince ends up killing himself later, so she takes over instead.
The princess in that case does start out on the wrong side, but eventually joins forces with the good guys.
Queen Remedi from Final Fantasy Tactics Advance: no king to speak of, but her husband is the Judgemaster Cid. She is in fact the embodiment of the Grimoire that created the world.
Queen Louveria from Final Fantasy Tactics, Remedi's predecessor. She confines herself to Offstage Villainy but her actions have ripple effects throughout the plot. If you read the character profiles over the course of the game, she eventually murders her husband and exiles/executes her way through most of his retainers just so her (possibly illegitimate) son has a better position in the coming civil war. She's apprehended and tossed in the dungeon of an impregnable fortress and the attempt to rescue her by her brother Duke Larg ignites the "War of the Lions".
Several NPCs' comments throughout the game indicate that Ambi herself is normally kind, fair, and a bit of a dreamer, so she's an aversion when outside of Veran's influence.
Luminous Arc 2 subverts it with a very kind and capable Queen who gives out the orders for most of the game. While she does try, at one point, to kill or imprison the party, she does so in order to try to prevent another war between magicians, and is quick to help the party once she learns that she has been mislead by a traitor in her inner circle.
Secret of Evermore has a queen and no princess. There's also a king, but the queen has the power. Even after you find the real queen, who is likable.
From the protagonists' perspective, Queen Azala. Then again, she seemed to do good for her people and ended up a villain only because the Reptites and Ayla's tribe were fighting each other for survival in the primeval world.
Fire Emblem: Radiant Dawn has an aversion of this with Queen Elincia, who in her arc of the game must deal with a rebellious noble who wants to be Crimea's leader and obviously doesn't have Crimea's best interests in mind. She later joins the rest of the cast in helping save Tellius. Of course, she was a princess in the previous title Path of Radiance. Also there is Micaiah, who becomes Queen of Daein in the game's epilogue; and (blunt but good-hearted) Nailah, Wolf Queen of Hatari. The last female ruler is Empress Sanaki, who is Wise Beyond Her Years and the only member of the Begnion ruling class not corrupted and evil.
Radiant Dawn also plays this straight with Queen Almedha, a mentally-broken woman who said that she was willing to sacrifice all of Daein to save her son... or at least, the man she thought to be her son.
An even bigger subversion occurs in Fire Emblem: Fūin no Tsurugi. The entire plot revolves around the band of heroes trying to remove Zephiel, the Axe Crazy omnicidal maniac King who once was a nice prince... before being broken from the throne and replace him with his younger sister, the compassionate and diplomatic princess Guinivere.
Averted in Fire Emblem Thesacred Stones. The Queen we meet, Ismaire, is very wise and well-loved in her kingdom of Jehanna and dies tragically in Eirika's arms. Likewise, when L'Arachel becomes Queen of Rausten, she's mentioned to be an eccentric but popular and wise ruler.
Sarah Kerrigan, self-styled (and earned through serious ass-kicking) 'Queen Bitch of the Universe', from Starcraft.
Played straight in Jagged Alliance 2, where Queen Deidranna Reitmann is petty, vain, abusive, and sadistic. The only things that get her to smile are the fawning of rich sycophants and the very painful killing of people who are bold enough to oppose her.
She is, in fact, one of the most frustrating evil queen's ever. Not because she's particularly effective at being evil (depending on the difficulty level, she's either stupidly easy or sickeningly difficult in her plans), but because when you finally, finally get to confront her at the end of the game, she says, literally, two words in surprise, and then dies just like any other enemy. There is absolutely no satisfaction in a final boss fight.
World of Warcraft has Elder Crone Magatha Grimtotem, chieftain of the Tauren's Grimtotem tribe and is one of the highest-ranking Horde officials in the game below the racial leaders. Her husband, the original chieftain, died in a "climbing accident." Her kinsmen are evil and stopping their schemes is the object of many quests for Alliance and Horde players alike. She has ties with the Undead and her ultimate goal is to make the Grimtotems the Tauren's ruling clan, even if that means killing Cairne Bloodhoof in the process, whom she loathes.
And who could forget Azshara original queen of the night elves. Almost succeeded in summoning Sargeas the biggest Big Bad in the series. After being defeated she and her followers were all turned into snake people.
Then there's Lady Katrana Prestor who, before King Varian Wrynn's return in Wrath of the Lich King, basically controlled all of Stormwind by socially manipulating the boy-king Anduin Wrynn and magically manipulating his guardian Lord Bolvar Fordragon. Oh, did I mention she's actually the black dragon Onyxia and is sowing chaos throughout the kingdom to bring it crashing to the ground from the inside?
Averted with Alexstrasza the Life-Binder, one of the great aspects who is called Queen of the Dragons in Wrath.
Also Sylvanas, the Banshee Queen. Yes, her history is tragic. Yes, you could argue that she's only ensuring the continuation of her people. But you can't get around the (self-admitted) fact that the only difference between her and the Lich-King is that she serves the Horde.
Even that can be argued, as she is now demonstrating an increasing willingness to ignore the Warchief's orders. He's explicitly forbidden her to animate new Forsaken, and explicitly forbidden the use of the Forsaken Plague, and she's ignored both commands quite blithely. One suspects that if Thrall were still in charge, he'd have yanked her choke chain by now, but Garrosh doesn't seem to have a leash on her.
MapleStory has Ariant Queen Areda, a greedy queen who cares only about jewels, and not about her kingdom. While Ariant also does have a king, he's portrayed as lazy and wimpy, and not wielding any actual power. In a series of quests, the player joins a group of rebels against the queen, steels jewels from Areda, and redistributes them to the villages.
The backstory of Soul Blazer is that King Magridd ordered Dr. Leo to summon the demon Deathtoll to the world, who would grant the king one piece of gold per soul. Although you at first think he's done this out of his own greed, it's later revealed that he did it with the intent of giving a gift to the queen, who is revealed to have manipulated the entire thing. While the king shows genuine regret at what he's done (considering that Deathtoll has taken every soul in the kingdom, including the Magridd's own), the queen is unrepentant to the end.
Queen Arshtat Falenas of Suikoden V. She's nice so long as she's not going insane from bearing the Sun Rune. Which is basically every time she acts as a monarch and not as a mom. And being a Queendom, of course, the Queendom of Falena has been in a state of near or outright-civil war for a few generations. Though it's more stable after the end of the game with Lymsleia as queen, though.
Among the back stories, the Queens before Arshtat had an assassination group — and during the last civil war, the competing princesses had each other's husbands killed, and when the eldest abdicated out of weariness, the younger (Arshtat's mother) had her sister killed.
Mortal Kombat 3 gave us Edenia's Queen Sindel, who was resurrected by Big Bad Shao Khan into doing evil things. She changed sides afterwards and is now on the side of good along with he daughter Kitana, making this something of a subversion.
Not so much in the reboot when Shao Kahn purposely gave most of Shang Tsung's strength to her, making her brutally kill the majority of the Forces of Good and was only stopped by Nightwolf's Heroic Sacrifice.
In Dragon Age: Origins, the trope may be subverted; while willing to do what she has to to become ruler, if the player gives her the throne Anora turns out to be a pretty good one.
...and then played straight in Awakening with The Baroness of the Blackmarsh. While not a crowned Queen, she was the Orlesian governor of the area during the Occupation, and a blood mage who used the blood of innocent villagers to keep herself young, then trapped the whole town in a Lotus-Eater Machine. Depending on your decisions, the female player character can also exhibit elements of this trope as ruler of Amaranthine.
In Dragon Age II, Knight-Commander Meredith isn't the queen but is more or less the actual power of Kirkwall. She rules with a fist of iron and is particularly merciless where mages are concerned, but you'll find out that all of this is out of necessity (with the whole Mages and Templars' Vicious Cycle being much more complex in the city) being that she does keep order, and the mages truly are the danger the templars fear due to the Veil in and around Kirkwall being thin and full of holes due to the actions of the Tevinter Imperium. People need actual saving from her when she goes over the edge later in the game due to getting a sword made out of that evil lyrium idol you find in the Deep Roads in the first act.
Just how justified Meredith's persecution of the mages in Kirkwall was is subject to interpretation. The game casts her as a fairly sympathetic Well-Intentioned Extremist if you side with her and an Ax Crazy megalomaniac if you support the mages instead. Either way, though, quite a bit of the blood magic use in the city is caused by desperate mages reaching for the only available method of fighting back against her increasingly harsh policies against mages. Hence the previously mentioned vicious cycle.
In Guild Wars, Varesh Ossa. She's "Warmarshal" of Kourna (think a sort of shogun) rather than a crowned queen, but she fits this trope neatly as the Nightfall campaign continues, acting like a classic tyrant; she hits her Moral Event Horizon when she orders the massacre of the priests of Lyssa at their chief temple in order to clear the way for a key ritual to free the dark god Abaddon from his prison. This sets up a key Heel Face Turn when General Morgahn, Varesh's best general, defects to the player's side out of horror and outrage at the atrocity against the clerics of his patron goddess.
Queen Nanesi, a character in Siege Of Avalon, comes across as a sweet and bubbly subversion, charming the dickens out of everyone. It turns out that she's one of the major forces on the side of the Big Bad all along, and is part of the reason your character is suspected of treason at one point.
Enrique's mother, the Empress of Valua, in Skies Of Arcadia. Because of the fortress-like nature of the terrain surrounding the city-state and the strength of the imperial navy, she takes this as carte blanche to pursue whatever variety of foreign policy she likes, and what she likes is forcible conquest. Not even her own people are safe; most of her legislation has created such a gap between the rich and the poor that in the outer city, bread soft enough to eat without breaking your teeth is the stuff of myth and legend. So convinced is she that Valua, and by extension herself, is invincible that she refuses to budge while her son is begging her to come with him because the palace is literally crumbling around their ears (this has predictable results). Her name? Empress Teodora (see real life below).
One of the scenarios that can determine the hero's personality in the Updated Rereleases revolves around a queen who lies to her husband and leads him to declare war on another country... simply because she covets the jewelry worn by that kingdom's queen. While the hero overhears her Evil Gloating, they can't expose her outright; instead, the Secret Test of Character hinges on whether they choose to obey their ruler's orders despite knowing the truth.
Meanwhile, Zipangu is led by Himiko, who encourages her followers to keep Dying Like Animals and sacrificing young girls to theOrochi. She refuses to entertain even the thought of trying to slay the beast... and when the heroes try, they discover that Himiko is the Orochi.
Queen Protea of Granorg in Radiant Historia bears a more-than-passing resemblance to Empress Theodora from Skies Of Arcadia, right down to having an heir-apparent who futilely resists her greed, egomania and expansionist ambitions. In her very-first appearance, she goes on a lengthy rant about how living in outrageous opulence while the people starve is perfectly okay, since she's such an amazing individual that her mere presence imbues the life of the 'common rabble' with a purpose - they should be happy that they get to toil in poverty for her leisure. If nothing else, she does a great job of setting herself up as someone youREALLYwant to slap.
The Snow Queen is the primary antagonist of the third Dark Parables game, Rise of the Snow Queen. Given the series' tendency to flip tropes up, down, and sideways, there's more to this situation than it initially appears.
In Märchen Maze, the Final Boss is a queen, though it's unclear whether she's supposed to be the Red Queen, the Queen of Hearts, both or neither.
Jim as Padme Admidala in Darths & Droids, although Padme is no longer Queen of Naboo when he takes over, turning this into God Save Us From The Senator. Immediately after taking the role of the character, Jim interrogates Padme's body double after an assassination attempt while she is lying on the ground dying, threatens to eradicate Bail Organna's entire planet if he does not vote in favour of creating a Grand Army for the Republic, and constantly tries to have her Not So Evil Chancellor, Sio Bibble (which Jim keeps mangling as "Bubble"), executed just for having a goatee.
Girl Genius: It's implied that Albia, the 'undying Queen' of Britain may be an example of this, although the only British character to appear so far is Ardsley Wooster, who's on her side (so far as we know) and wouldn't say anything to support this idea.
It's weird. Gilgamesh tried to send Agatha to England for safety, but he later said "to go against Albia's merest whim is literally unthinkable", which sounds like Other-level mass mind control.
Lucrezia could probably be nominated for this role as well - she was married to THE Heterodyne, and even better a beloved Heterodyne (instead of the usual 'feared') — but outside of popular stories told by the public, she was not well thought of, particularly by the staff. She also was The Mad Scientist's Beautiful Daughter and had her own powerful Sparky gifts, although the details on those are still fuzzy on the reader's end yet.
Homestuck has a particularly nasty Black Queen of Derse. Ignores the battle that's raging on Skaia, lets her agents go unchecked, pretty much lets her own king be slaughtered... oh, and she forces JACKNOIRto put on funny outfits. It didn't end well for her.
The queen of the trolls, Her Imperious Condescension, flies around the universe in her ship greeting new civilizations with politeness. She then leaves and sends a portion of her vast army to annihilate her new acquaintances. And then once she signs on with Lord English, she becomes Betty Crocker and sets off a series of disastrous events, including taking over the Alpha Derse by dethroning the Black Queen.
Which she then tops when it's revealed what she did to Earth: Taking over, attempting to re-create her Troll empire and culture on humans (prohibition of natural breeding, the ICP nominated as subjugglators), death camps killing 5 billion, various experiments... To the point that Dirk and Roxy are the last human survivors of their time.
Hera in Thalia's Musings, to Zeus' paramours, their children, and any of their sympathizers. However, her hatred toward her stepson Apollo doesn't extend to the Muses since she finds them entertaining.
The Questport Chronicles subverts this with the ruler of the titular village, who is shown to be quite a fair and competent ruler.
In A More Personal Union, after Francis II of France dies and leaves behind a toddler son, his mother Catherine, the Queen Dowager of France, and his wife Mary, the Queen Consort (and other Queen Dowager) of France, spend the entirety of their regency locked in a rivalry, jockeying for power. The state of the country is secondary in this contest.
Played straight and subverted in Gargoyles. Lady Titania is one of the series' few benevolent Fair Folk, and was second in command only to Lord Oberon. He, despite sometimes meaning well, claiming to be fair and honorable, and trying to be considerate towards mortals, is nonetheless arrogant and drunk with power. Of course when a human notes that in Avalon, the Fair Folk's homeland, Oberon is always right, Titania notes that such a statement would be true, if not for the fact that Oberon is married. Word Of God also has stated that Titania was once much less benevolent than Oberon, that it was her bad behavior part that got the entire race banished from Avalon for 1000 years, and that Queen Mab, Oberon's batshit insane mother, was even worse than them both. Even the Fair Folk are mostly glad she got overthrown.
Most Disney film queens would go here. A classic would be the unnamed witch-queen of Snow White *
Zira, the main villainess of The Lion King II was actually implied to be a queen somewhere about halfway through the first film, back when Scar was still in power. She was immediately removed from the throne after Simba took over as king (and Scar being dispatched by his own hyenas).
Very much subverted in Tangled. Despite having very little screentime, the queen is clearly beloved by all of the kingdom. Heck, the entire opening of the movie is about every person there trying to save her from dying.
Another Disney aversion: Atlantis: The Lost Empire actually provided us of a rare glimpse of a princess becoming a queen at the end of this (or any animated Disney) film.
Other Disney aversions include Queen Sarabi from The Lion King (and you could say Queen Nala eventually as well), and also the Queen from Sleeping Beauty. You can even count Queen Athena from The Little Mermaid, who shows up in the prequel.
Becoming this trope was arguably also the goal of Nightmare Moon, though since her attempt failed in only the second episode we'll never know just how bad her reign would have actually turned out to be.
Since Nightmare Moon's true goal was eternal night, it is implied that the lack of sunlight would have probably caused the gradual extinction of all life in Equestria.
Used in the second season finale, with the Queen of the Changelings, Chrysalis.
In which case, a god really does try to save them from the queen and fails! (Assuming Celestia can really be called a god, that is - she's never explicitely referred to as such on the show.)
Also, Princess Azula was the fourth in a family of psychos, and her (male) predecessors were all evil too.
Averted with her mother Fire Lady Ursa, as she was quite respectable and sought to protect Zuko from Azula.
In fact, the only thing that doesn't really add up with Fire Lady Ursa is how she ended up with Ozai and had two kids with him! I mean, the guy was so evil they had Mark Hamill voice him. You don't get that unless you're really evil.
Word Of God says it was an arranged marriage, and were happy for the first few years.
The Queen of the Crown in Adventures Of The Galaxy Rangers is depicted as the ruthless tyrant of a crumbling empire. The episode "Tortuna" mentions that she destroyed all but a handful of cities on the planet Tortuna and nearly drove an alien race to extinction in her thirst for Life Energy. She also enslaved an entire planet to create a BFG she used to blow a hole in Earth's moon.
Played straight and averted in Teen Titans: Blackfire takes over her homeplanet "for kicks", then fakes an enemy invasion — of her own home planet. Starfire wins the crown but quickly gives it to her mentor and surrogate father, as she already has a job on Earth.
Subverted in Don Bluth's Thumbelina, in which the fairy queen is quite nice (if not present very often).
Played with in The Prince Of Egypt. The Queen is a loving mother to both Ramses and Moses, and doesn't care at all that Moses was a Hebrew child that washed up in a basket. On the other hand, from the perspective of the Hebrew slaves, none of the Egyptian royal family is particularly sympathetic or kind.
Played in and subverted with Marceline, The Vampire Queen in Adventure Time. Played straight with Quartzion the Crystal Queen (Tree Truks after eating the Crystal Gem Apple) and the Ice Queen. Totally averted with Lady Rainicorn, the "Rowdy Queen" of the Cloud Kingdom.
This trope is touched on in The Nostalgia Critic review "Why All the Princess Hate?" The Critic criticizes the trope for continuing the implication that royal women should be satisfied with the title of "princess", which tends to have connotations of some power and responsibility, but not all, instead of imagining themselves in positions of highest power. He lampshades it with a comic conversation between Snow White and the evil queen:
This trope was invoked by the Anglo-Saxons of Wessex to explain a period in which they refused to grant the title "Queen" to female consorts of the king. According to Asser's Life of King Alfred the Great, a Mercian-born queen named Eadburh, wife of Beorhtric of Wessex, was reputed to have been a power behind the throne, urging Beorhtric to execute or exile advisers displeasing to her. At those times where the king refused to follow through on the punishments, she would take matters into her own hands poisoning them... until the goblet she had "prepared" for one enemy of hers accidentally ended up in the hands of her husband, who died along with the intended victim. Oops. This necessitated a quick flee to France, where she compounded her error, so the story goes, by snubbing Charlemagne himself by telling him to his face that she preferred one of his young and virile sons to him. She ended her days a beggar in northern Italy. Asser claimed that due to this, until the advent of the Frankish-born Judith (the second wife of King Aethelwulf and stepmother to Alfred) — whose father the Holy Roman Emperor refused any lesser title — the people of Wessex denied the word "Cwene" to the distaff royalty, allowing only "wife of the King".
In which Asser may have been mistaken, as in Old English cwene meant "woman" and the cognate form cwén meant "woman" or "wife of a king" (both words are related to Greek gyne). Cwene later evolved into Modern English quean "shrew, hussy, prostitute".
Whatever the justice of Boudicca's cause, the practical upshot of her short reign was about 70,000 casualties, mainly civilian, in Camulodunum (Colchester), Londinium (London) and Verulamium (St. Albans), and the loss of probably as many Iceni warriors in her final battle at Watling Street.
Catherine the Great, Empress of Russia for 34 years in 18th century, might be considered an example. She came into power through a coup aginst her husband, Peter III, whose death she may or may not have orchestrated. Also, she surely fits the "behaving like a powerful man" part: She had several lovers, some of whom she dumped when they stopped being useful to her.
Ranavalona I of Madagascar qualifies - a staunch defender of indignenous Malagasi beliefs, she made conversion to Christianity by her subjects punishable by death, and once executed 15 local church leaders by dangling them from thin rope over a 150-foot deep ravine.
Constance of Provence, the third wife of King Robert II of France, is perhaps one of the great evil queens in medieval history, called a femme noire by the historian Jean Dhondt. Her husband's best friend, Hughes de Beauvais, tried to get Robert to divorce her, and Constance, unwilling to end up in the ex-queen scrap pile like the last couple of Robert's wives, convinced her cousin, Fulk Nerra of Anjou, to put a hit out on the guy. Hugues de Beauvais was brutally murdered in front of King Robert, who was so horrified that he tried to divorce Constance, only to be forced to take her back by political and religious pressure. In another incident, Constance struck a priest in the eye with the royal scepter in a fit of rage, and put his eye out. She was also known to threaten torture of servants she suspected of stealing (her husband, King Robert, would sometimes give thieving servants a head start to escape the queen's wrath). When her eldest son, Hugh Magnus, demanded political power from his parents, Constance turned her back on him "as if he were an enemy, born of another lineage", according to a contemporary chronicler. Forsaken by his parents, Hugh Magnus died young, an exile and a fugitive. After their eldest son's death, Robert and Constance quarreled over which of their other sons should succeed to the throne. Robert preferred their second son, Henri, while Constance favored the third son, Robert, who's temperament was similar to hers. Constance encouraged her sons to rebel and sack and pillage castles and towns belonging to their father. King Robert managed to make peace with them, but when he died in 1031, Henri became king, and almost immediately Constance was at odds with both her sons. Henri ended up laying seige to his own mother; Constance only surrendered after he vowed to slaughter everyone in the castle with her if she didn't.
The popular image of quite a few historic queens was shaped according to this trope, often in the form of Historical Villain Upgrade. In France, for instance, Isabeau of Bavaria (consort of Charles VI the Mad) was sometimes portrayed as a scheming adultress who betrayed France by persuading her husband to accept the humiliating Treatey of Troyes during the Hundred Years' War. Catherine of Medici, consort of Henry II and mother of three kings of France, was (unjustly) suspected of poisoning several of her enemies and of masterminding the Bartholomew's Night massacre. Marie-Antoinette, despised as "l'Autrichienne" was widely believed to be uncaring about the sufferings of the poor (with the fabricated quote "let them eat cake"), a sexual deviate and also the real power behind the throne, while she actually had little or no influence on Louis XVI's policies.