Here's what I WANT to happen:
It will end with Jon lopping off Dany's head. "Whoever passes judgement must swing the sword." He will have a kingdom of ashes, burnt countryside, and killed the queen he was loyal to. There must be SOMETHING glorious to happen. Otherwise why make a Song about it?
Here's what I THINK will happen:
Dany will rule in fear. Jon will be exiled to beyond the wall because of their history. She will execute Sansa and probably burn Winterfell to the ground. She gains the throne but never knows love ever again and lives only through fear, skulls, fire, and blood.
TBH, I am beyond excited for the ending. Not only will we finally be free from GRRM, it's for the first time watching the show I'll be not be able to predict the overall story beats. What happens AFTER the Mad Queen ascension? I have no fucking clue and that excites me. I have no idea what's going to happen.