Pros and Cons - What are your thoughts on Water Cooling Systems for PCs?

Just as the question says. Right now my PC has 6 fans… SIX FANS on it and they manage to keep the machine “cool”, or internal case temp below 98 degrees under stress.

A lot of people have ginormous heatsinks and fans over their processors, heatsinks on each stick of memory, on their video cards, on their video card’s memory, heat sinks and fan combos for their hard drives… etc

But I was wondering, would water-cooled PCs yield an even greater temperature benefit over traditional heatsinks and fans?

My PC is being used “harder” than most people’s PCs: 3d rendering and animation (as in, not games) as well as HD Video Editing over timelines of many hours.