This game has quite a bit of history behind it. It was the fourth Choice of Games title, when they were all named 'Choice of' (the ones before it being the Dragon, Broadsides, and the Vampire). A year later, it received an update with an entire new chapter, and then another update.
It's power fantasy in its purest form. You are young and gorgeous and everyone wants you, including the king/queen. You can choose everyone's gender in the game and due to magic any two people can have a baby. Tension in the kingdom is preserved, though, by replacing gender with magic. The type of magic you are born with determines who can rule.
Every choice you make has massive consequences. You are constantly romancing someone or making backroom deals or starting a war or revolutionizing the system or jousting in a tournament. I found it very similar to Sims in the way you can meddle with everything and everyone.
Being so early in the history of the company, it has a lot of odd quirks. It has three major paths you can choose, but only one leads to the updated content, the others ending with your old age and death after seeing only a third of the content. There is a lot of customization of your appearance that ends up not mattering. Some of your bases stats are rarely checked. There are a lot of binary choices, and there are several 'huge list' choices where you have 7 or more choices. The narrator comments on your choices to you directly, something I only remember seeing in Choice of the Dragon.
The game is full of the eponymous affairs. I do not support affairs in real life, but this is a fantasy, and more than that, it's a fantasy that shows the real-life problems, jealousies, and conflicts that are the natural consequences of affairs. I think it's worthwhile to play and fun, to boot.