I can never condone Loghain. So in my "good people" ending, it's always Alistair married to Anora and the Warden do Ultimate Sacrifice.
Usually, I always put a headcanon with a rogue having DR, and a mage having ultimate sacrifice.
Agreed. I see the value in the Redeemer ending, and from a good guy perspective, it fits in with a save everyone stance. But I just can't bring myself to give Loghain a second chance after all the lives he's ruined. There are far more deserving candidates just out of the lives he's had a personal hand in destroying - Jowan, Cailan... letting him redeem himself as a hero is a big kick in the teeth for his victims imo. It doesn't feel like a “good” choice, as the good can't always turn a blind eye, as it will be the innocent who will pay.
If Loghain showed any remorse before the point in which would make our decision, it would make more sense to offer such redemption. Out of the other recruitments that are dubious Sten does speak of a wish to atone, iirc, and Zevran can at least move you to pity and it's not personal with him.
But most of all, letting Loghain die a hero is in no way a punishment when the alternative is ignoble execution.
I think letting Alistair execute him at the Landsmeet is a sort of good ending – better than having to endure death by hanging, which Alistair says at Flemeth's is what will happen to him – this being probably the traditional punishment for crimes of such nature. In comparison it's a merciful death.
The possible repercussions of the dark ritual make it too chancy, and I think a “good guy” would avoid it, and he wouldn't let Alistair die in his place, so yes, ultimate sacrifice.