IMHO
I used to really enjoy overclocking. I'm a dinosaur, in the early days you could make changes to cpu parameters with a conductive pencil mark and changing jumpers on motherboards.
Lately, I've been able to get decent compact builds that run cool without watercooling. Also, I do a lot of tweaking, after its assembled, and the water cooling makes everything a longer and more complicated process. There was a time when cpus were not locked and getting the most out of them was an art. I enjoyed that. However the "unlocked" cpus of modern times are in the same price point of the next chip level above the original unlocked cpu. If I buy the top of the line cpu, I'd use watercooling to go further, but halo cpus are not unlocked. Lastly, overclocking does not yield the relative performance yield in real-time results. Example, folks that overclock the heck out of their video cards to get a high benchmark score - simultaneously the same settings couldn't be used to play 15 hours of gaming without texture flashing, and other issues. A pc should be able to be turned run, and run for 30 days without someone pouring cryogenic liquids on it to get it to work. That stuff is fun just for a dragsters. My pc is my daily driver. So think of it as a practical Lamborghini Urus daily driver, and not a dragster where the engine and tires give their life on the first run.
So I max out the build to provide the most consistent performance and not worry about the liquids, the evaporation, leaks, pump failures, etc.
I can get more performance by enabling sli, dual sockets MBs, ram, drives, and correctly configure the OS to be a tool and not get in the way of what I'm trying to accomplish. Correctly configuring things will often yield better results than a poor configuration and some overclocking.
So Id o like water-cooling/overclocking, but the ROI is not what it used to be I think I was the first person to simultaneously water-cool dual cpus, the chipset, and the GPU at the same time). I actually had to CNC a lot of the blocks. Example, I was the first to water-cool rambus (Rambus would normally run a few degrees over meltdown temperatures).