but he kept trying to tell me this corsair water cooler is better than any kind of fan.
The Corsair self-contained water coolers are OK.
Top tier air cooling is slightly superior to the Corsair H50 (lower temps)
You have a fan either way.
The radiator has to have a fan blowing over it.
With water cooling, you also have a pump.
The Corsair pumps aren't particularly loud... but they're not silent.
Outside of self-contained units, water cooling is more of a PITA than its worth.
You can run a SandyBridge 2600k at 4.5GHz (cool and quiet) with a top-tier air cooler.