If anything I'm more hyped now for the books. Most important plot points this season were good, the execution was just shit. Jon and Dany's arcs ending like this is classic GRRM. It's like people forgot about Ned's death and the Red Wedding. Those dark twists would be bad too without the proper build up which is what was lacking here.
Of course butthurt Dany fans didn't like the Mad queen direction but it fits and makes her more compelling. It's ridiculous to act like this is some sort of sexist message when many men in the show have been way more fucked up and crazy (and went out in bad ways), yet no one whined there. People who want Disney power fantasies for Jon and Dany were reading the wrong series