So many of these things seem to start out tight, then just drag out forever. I have more experience in the TV-series side.
I am happy to not have all the answers, I'm happy to watch something overarching that goes on for a while, I'm even happy to watch something that ends ambiguously. But I've got little and ever less tolerance for those authors who think the way to make their universe last longer is to never resolve anything. No... you resolve things, and then there are more things. Preferably consequences, anticipated and otherwise. Just like, you know, real life. Don't simply stretch your story out... and out... and out... and out...
Stargate SG-1 attained the nearly-perfectly-correct balance for me. And it made some of the developments in that series legitimately surprising to me, when they actually upended their universe a bit in several of the season finales, because I so casually expected "nothing to ever change" in a series like that. (Now it's more normal, but at the time especially I was surprised by their boldness. They never did quite take the step of making the program public knowledge, though...)
(Special callout for Alias, by the way, who also scraped against my brain in such a way that I'm also extremely irritated by "but wait, there's a conspiracy behind that"... by the fourth or fifth time it's like the dream hallway that never ends. And my suspension of disbelief really breaks down too... how, exactly, does one become the guy in change of the conspiracy under the conspiracy under the conspiracy under the conspiracy under the conspiracy under the conspiracy? Is there a college track I should be focusing on for that? Does the n+1th conspiracy conduct secret interviews? Is a member of conspiracy-4 really supposed to be surprised to discover conspiracy-5?)
I had similar problems with "Alias." You can't just upend who is good and who is bad every month. It isn't believable, and it feels like you're playing with your audience. It also indicates you have no idea what you are doing (= no end point). I watched season 3, and quit early on in season 4 after I realized...
Once I type my credit card in it flips the "when is it going to get here" switch in my brain and the obsession sucks. I preordered an Apple Watch and spent so much time checking shipping status and hanging out on /r/applewatch that by the time it actually showed up the thrill was gone.
There's a bunch of psychic overhead involved in preordering something -- or watching/reading a story that doesn't end -- and the anticipation completely outweighs the payoff.
I'm surprised that the Amber series hasn't been developed into a film (someone surely has the rights). Swords, sorcery, inter-world travel, dysfunctional royal family. It's got it all.
I personally quit reading the series somewhere around book 6 or 7, but it wasn't inability that kept him going...it was sales.
GRR Martin, on the other hand, I firmly believe lost track of his story. I don't think he would ever have made any more headway on it had it not been for the HBO miniseries and all the help and fan-made reference pages that cropped up as a result. I predicted for years that the story had stalled and would never see anymore progress during the mid 2000's.