Most air coolers between $55 and $80 will outperform any CLC type water cooler costing up to around $120. If ya spend $140 for an OLC (open loop cooler), that gets you:
1. the ability to add other components (Rads, blocks, reservoirs, whatever
2. copper instead of cheap, inefficient aluminum radiator
3. pump that is mounted on form / rubber isolators
4. the ability to change fluid, color or add coolant additives when original loses effectiveness.
5. much better performance
6. much lower noise than CLCs
7. can get a GFX card with pre-installed water block (i.e. MSI Seahawk), slap it in and now both CPU and GFX water cooled.
So while there's numerous advantages from AIOs once ya break into the OLC category, CLCs just don't deliver anything. Air coolers have a song ...
https://www.youtube.com/watch?v=UnEtY_58pWg
You can the subject matter treated seriously here.... skip to 22;55 mar if ya just want the numbers.
https://www.youtube.com/watch?v=PYKdKVxbnp8
Using the Noctua NH-D15 as a base point, we see it keeps the CPU at 70C while keeping noise down to a rather hushed 33 dbA. The Corsair H100i can't quite keep up leaving the CPU 3C hotter, but even to do that it must be 12 times as loud... easy decision there.... more heat, more noise... no thanks.
The H240-X manages to beat the Noc by 6C but to do that it's about 2.5 times as loud. So here you can get a substantial thermal improvement but its costs ya some noise.
$150 = Swiftech H240 X2
$140 = Swiftech H220 X2
$80 - Noctua NH-D15
$65 - Phantek's PH-TC14
$50 - Cryorig H7 and several Scythe Coolers
$25 - Hyper 212