Water cooling is just a way to transfer the heat to a larger heatsink somewhere else. It doesn't magically absorb the heat but just adds complexity and overhead. If there's a way to make a direct heatsink work, then that's the more convenient option every time.

For datacenters it would make more sense to make it all water cooled though, since you can likely have one central loop connected to an HVAC unit or something.