My sister has a Corsair H100 hand-me-down from about 10 years ago, that's still going strong.
However, with matters like this, it's unpredictable. I had a 280 ARCTIC Liquid Freezer II which lasted 1 week before the bearing in the fan on the block started buzzing and broke.
It largely depends on the CPU and what you'll be doing it. If you're buying a 13900K to earn money with every day, it might be worth getting a big AIO from the latest generation for example.