I should point out a historical fact real quick, in the vein of most monarchies being more or less bad, or uninteresting at their jobs to be notable in any way.
Let's be honest, how many ruling dynasties can you all name with complete lines of succession? How many kings and queens have achieved greatness during their reigns for being absolute authority figures?
or
We can probably name some big ones; William of Normandy, Edward I, Elisabeth I, Charlemagne, and so forth.
But for each famous one, you have a slew of notorious ones, Charles the Bald or Adolf Frederick come to mind, as do Alfred I or Louis the German.Others that are famous were really terrible rulers, Henry VIII or George III for example.
Not to mention why many of these men and women who were excellent rulers had little to do with their power an exertion as kings or queens, but how they played the game. William of Normandy conquered the British Isles, then set up tax codes with the Domesday Manuscripts so people would continue to give him tribute. Charlemagne conquers most of the Germanic states with the Popes Blessing, and sparked the Carolingian Renaissance for a time, a focus of education and intellectual pursuits within the church to keep the people pacified. It was not just about killing and showing an iron fist, it was a world of give and take that made them really successful.
What are the others famous for? Charles the Bald bribed the Vikings with nearly 7000 pounds of silver so they wouldn't invade his holdings and take Paris, and they continued to raid France anyway. Henry the VIII was more interested in finding a male heir, then broke away from the Church when he didn't get his way in annulling his eighth marriage. And poor George III was effectively the puppet of the British Parliament, a narcissistic Tyrant, or a flawed, sick king, depending on who you ask and which historian is writing the book on him.
I think the problem we see is were romanticizing what a monarch should be, over what they are. How Dragon Age or The Witcher or Dungeons and Dragons or whatever have you does a king or queen, or ruler of a hold, it's done in a way that is a pastiche of ideal, or not so ideal, traits we believe such kings and queens need to have, traits that very few people even posses, let alone can enact on properly.