The closest I can recall coming to this is Final Fantasy XII. Not that I didn't like the big climax at the end, just that the last couple of dungeons before it were a chore and nowhere near as fun as the rest. I was ready for the climax after that.