I've spent a lot of time thinking about the story of GoT and I've honestly come to two conclusions that somewhat mellowed my views on the final two seasons.
1. There are way too many side stories and minor arcs that even George RR Martin himself doesn't know how to deal with properly
The TV show cut a lot of these short, Dorne / Tyrells / Iron Island etc. Some needed way more time, but it makes perfect sense from a storytelling perspective that they needed to clean up. Admittedly, I think Dorne suffered the most here, but the Tyrells were handled pretty well.
2. Bran becoming the King, everything Azor Ahai & Prince(ss) That Was Promised, Jon not being the big hero, and Daenerys going mad are all in line with George RR Martin's literary inspiration, and most likely would've happened in the books as well
Because it's all straight from Dune, which is a huge inspiration for George RR Martin. All of Dune is a warning / cautionary tale against prophecies, heroes, and chosen ones. We see that arc with characters like Rob and Stannis, but also with Jon not having a huge role in The Long Night.
He still gets everyone to band together, but he and Daenerys don't fulfill the prophecized roles we expected. Azor Ahai just turns out to be another Lisan al Gaib that the Bene Gesserit, sorry Red Priests, are spreading (mis-)information about.
The prophecies we followed, the people we were looking at to lead us, ultimately didn't. Bran (with his prescience), like Kwisatz Haderach before him, becomes a leader. Yet another aspect of Paul's journey in Dune. Except since we're spreading this arc over different characters here, Daenerys is the one who goes mad here, rather than Bran.
That doesn't mean the version in the show wasn't rushed, but the logic tracks IMO. The execution just could've been a lot smoother if they had taken their time.
Edited for clarity.