No, not even the top CPUs are worth it, (in term of max performance gain vs money spend)
I know that is kinda apples and oranges, but never is the highest cost component cost effective.
That being said, I'm pretty sure, water won't overclock, any better than the best phase change coolers. (still expensive)
edit
Waters other advantage, quiet operation.