Even for killing the queen, Jon Snow might actually have gotten a happy ending. After killing his complicated love, he's imprisoned with no real sense of what'll happen to him with no ruler in place to decide to his. Greyworm wants him dead, and his sisters obviously do not. As a compromise, he gets sent back to the Night's Watch. (We're all thinking what Jon said in the scene where Tyrion, now hand of the king, yet again, delivers his sentence: "There's still a Night's Watch?") He has to say goodbye to his family, but he gets to live, and the last shots of the show are him, Tormund, Ghost, and the Wildlings traveling North.
Tyrion, as a prisoner, manages to talk the Lords and Ladies of Westeros (including a much more suave-looking Robin Arryn of the Vale) into electing Kings and Queens. They don't say "President" or anything, but it is clear from Sam's suggestion they have a pure democracy getting laughed off the dragon pit stage that the writers are nodding to the idea that Dany's "breaking" of the wheel doesn't have to be killing anyone who ever pledged fealty in a feudalistic system of government. Not only does the Last Lannister get a king elected (pause for a moment to soak in the word ELECTED coming out of Game of Thrones, after all we've been through), but he successfully nominates Bran with a lame speech about the power of stories. So he's Bran the Broken, ruler of the Six Kingdoms (he lets the North remain independent, as Sansa sticks to), protector of the Realm. By the very end of the episode, King Bran is still warging around, keeping an eye on the one dragon in the world, while his still-growing Small Council -- Master of Coin Bronn, Archmaester Sam Tarly, Head of the Kingsguard Brienne of Tarth, and Davos Seaworth as Master of Ships -- debate how to keep this proto-democracy going.
The sisters Stark also get happy endings, relatively. Sansa keeps the North free, which is a huge deal in the history of Westeros. The Queen of the North promises the Northmen they'd never bend the knee again and she keeps that promise as the student of Littlefinger and Cersei that she has grown into. Arya, on the other hand, goes west, when she reiterates her question from two seasons ago: What's West of Westeros? She's dedicating the rest of her life to finding out what's going on beyond where the maps end.
It's a little frustrating to see Arya's end. She comes to an important conclusion by the end of her story, which is that she doesn't need to be constantly after revenge and death, but also she doesn't go full Batman after killing the Night King. Instead, she leaves and says she's never coming back. Westeros needs re-building and could use an assassin with face swapping abilities. Or were we supposed to forget that she had the ability to magically switch her face?
The finale had to balance two different tones: a harshing of our collective mellow as our girl Dany went the way of Dracarys mixed with lighthearted scenes like Edmure Tully getting laughed off stage after suggesting he could be King after being imprisoned by the Freys for years. Brienne finished Jaime's Kingsguard entry and Sam Tarly makes meta jokes about A Song of Ice and Fire and democracy. Game of Thrones was a literary narrative that came to a blockbuster television solution. It wasn't perfect, but we were rapt. And they did stick by Cersei's rules from Season 1: "When you play the Game of Thrones, you win or you die." Did you win?