I cannot disagree more with you about the Stolen Throne. It's very fresh in my mind because I just finished it. *spoilers ahead about the book*
Katriel was responsible of the death of all their army, and Rowan's father, and months of work and training. She is a traitor, she is a bi*tch and she totally knows it. I can't understand why everyone blames Loghain for "betraying Cailan" etc, but still say "Katriel was such a good girl, yes she betrayed everyone and was directly responsible of the death of 99% of the rebel army, but look, she tries to help them afterwards by showing the deeproads to them."
Come on, she was just selfish because she realized how bad she was, how manipulative she has been, and she helped afterwards only because she developed feelings for Maric, not for the good of everyone.
Loghain never manipulated Maric about Katriel, she showed him that she betrayed them, and it was totally right, and even after Maric killed her, and Maric discovered she finally didn't want to come back to her previous master, he didn't think "OMG, if I knew I wouldn't have killed her." No, that's too easy, her crimes are still there, and Maric knew that she changed her mind and helped them afterwards but still, knowing that, he killed her. And he did the right thing, he should not let his personal feelings interfere with that: would you really think that he could have made queen an elf who destroyed all his army because she was a spy and traitor, and then "oh I change my mind, can you forget everything I've done, darling? hihi".
No sorry, it doesn't work like that.
And NOWHERE Loghain said or thought that Katriel should be punished "because she was Orlesian", no, she is punished "because she betrayed them and led to death thousands of their people". She was an enemy. It was war. She was a spy, and it is how spies should be treated in time of war, no less.
And how could you blame him for giving Rowan a bit of confort? she was crying, in despair, while Maric (she was not in couple with him yet, because he even thought he would make Katriel queen and not Rowan!) was having sex with his elf just a few meters away. Why don't you blame Maric, then, for "betraying" Rowan? why do you just blame Loghain for trying to confort the woman he loved and who was REJECTED by Maric? even at the end, Loghain sacrificed his feelings for the good of the country, knowing that Rowan should be queen (and she thought that it was the right choice, too).
So no, I don't see any betrayal from Loghain there. The only one who betrayed was Katriel, how can you be so blind not to see that? or are you just blinded by your hate for Loghain?