The Corsair H60, a 120mm all-in-one cooler, is a good product so long as you realize what it is.
A 120mm cooler will not tend to run your CPU any cooler than a mid-range aftermarket aircooler. It is only a couple degrees cooler than the included cooler, in some cases (Looking at you, Wraith Spire, for being a good included cooling solution).
What a 120mm cooler will do is allow you to get the same cooling performance of a large aftermarket cooling tower in a much smaller package. While many cases, including small form factor mATX and mITX cases, support thin 240mm radiators, most people do not desire (or need) a $120+ cooling solution in those form factors. The H60 provides a middle ground between more expensive solutions, and cheaper but MUCH larger solutions, and it fulfills this role admirably.
The pump is small, and the hoses do not interfere with RAM. The included brackets cover the gamut of modern (and two-ish generations back) mainstream processor sockets, so you are highly likely to be able to use it out of the box no matter if you are team blue or team red. The included AM3/+ bracket even works on AM4 sockets, thanks to AMD's choice to use the same hook-mount specifications as AM3. How much of a pain that particular mounting system is, that's something else.
The pre-applied thermal paste is quality, and saves some effort. Really, even if you purchase more expensive pastes to replace it with, you MIGHT shave a single degree off your temperatures.
The hoses on this particular model are a matte rubber. Nothing fancy, but robust and flexible.
The radiator itself is a thin radiator, which provides a large amount of clearance even when coupled with a standard fan, without needing to purchase a more expensive (and yet lower-performing) thin-line fan. The thinner radiator does not significantly impact its performance, as the actual overall size is much, much more important than thickness (120 vs 240 vs 280 etc)
Overall, I would recommend this cooler to someone who really only needs a $40ish aftermarket air solution, but either wants a clean look, or has no way to fit that absolutely HUGE heatsink.