I generally agree, but I can name a few exceptions:

Detective stories, like Knives Out

Project Hail Mary

Outer Wilds

There’s an excitement that comes with not knowing the ending. I get to try to solve the mystery before it’s revealed. But yeah, if they’re good stories, I’l stilll enjoy them the second time I experience them.