It wasn’t about what I wanted or expected. More to do with the fact that Jon’s story arc of him being a Targaryen was ultimately meaningless. He was sent to the nights watch as his punishment, but what is the purpose of the watch? No white walkers and a friendly alliance with the wildlings. Bran was made king based of Tyrion’s speech, no more. 8 seasons of wondering who will end up claiming the throne and it is decided by a speech. Speaking of the throne, it was literally burnt to nothing, so no one even ended up claiming the famous iron throne. I’m unsure what I wanted as an ending, I like to be surprised and shocked, but I found this ending to be sorely lacking in quality writing and decision making.
The Targaryen regime was doomed once Dany decided it was about dictatorship. Dany had some right ideas but she was the wrong choice as implementer of them. Jon seems to have forsaken his opportunity by believing he was meant to serve Dany. But maybe those events had to happen to leave open the possibility of a genuine new era under Bran. He was waiting for events to slot into place so that he could bring his wisdom to the government of Westeros. No-one knew this but him though.