I imagine writing a book where you know the ending (not just the final scene, but the whole complete solution to the plot) beforehand is so boring, it would make writing the damn thing impossible. I mean at that point it's pretty much a coloring book. You came up with the shapes, for sure, but still.
I mostly share this experience, but for me it's a little bit more complicated.
I've tried to completely pants a story, and I've also tried planning stories out ahead of time in extremely rigorous detail, and I've ended up deciding to stay sort of in the middle. I generally have a pretty detailed idea of where I want a story to start and end, even down to some sense of how to get there, usually composed of some of the big events or set pieces or that happen in between, so I'm not pure pantsing, but then I just sort of find out as I go along how I get between each point, and really revel that process of finding out.
I think I've ended up writing things this way precisely because on the one hand writing a story based on a complete outline is extremely boring, it essentially becomes work, it just isn't Fun anymore, but on the other hand, I am an extremely set piece motivated writer — I am motivated to write things by specific scenes that I want to have happen or even specific vivid images — and so those scenes, spaced throughout my narrative, sort of act as the carrot on the end of the stick to get me to keep going to find out how I get there. If I go into writing a story without a sufficient string of high points and an ending, I'll tend to just sort of vaguely peter out after the last cool idea I did have in mind when I started and then lose interest eventually.
source - have written long-form fiction