What is your opinion on liquid cooling for computers?

When I upgraded my computer, I upgraded the fans as well. Everything stays cool enough, but I’m tired of listening to the “super quiet” fans hum all night.
I was originally opposed to it because at the time I did a lot of lan parties, but those have died down quite a bit. I rarely move my computer (if ever) and would love to have it run dead silent.

What’s your opinion on liquid cooling? Can I get my PC to run silently, or would I still need a fan for the radiator? Is the hassle/risk more than it’s worth? I’m looking for any and all info people can give me.