Concur with all the comments about avoiding the liquid cooled machines at all costs. This discussion compelled me to get out my PowerMac G5 dual core machine and see if it was still alive; it's one of my least-favorite machines of the thirty or so vintage Macs I have. It is alive, and seems to be OK. In the past it has been something of a problem, especially regarding reliably recognizing its memory (16GB, extraordinary for a PPC machine) and its disks. The SATA connection is only a revision I and I remember having problems finding drives that could work. It is running a SATA I hard disk and a Samsung SSD. Yes it does require the special AC cable and the PSU's are known to be unreliable. (maybe not as bad as the PSUs from an MDD; that's a machine I really hate). Anyway, the computer is on my bench running and I'll play with it for a while.
If you do buy such a thing, be sure that it is not missing any parts. The clear plastic air dam is essential, and the special plastic mounting domes for the disks are also commonly missing.
I don't even know where to start with this…
First off, I'm not so sure anyone said to 'avoid the liquid cooled machines at all costs'. There were a few warnings about the LCS, but I don't recall those exact words.
I had zero issue with the LCS on my Quad. It was a university Mac, used by a professor, given to another professor who shipped it to me. Four years ago when I put it away it was still functioning perfectly.
I've never cared for the design of the G5, but it turns out I do have a favorite and that is the one that you apparently like the least - the 2.3DC. It was quiet, reliable, stable and never gave me any problems. I did have an issue with one drive not showing up whenever I restarted the Mac. However, having dealt with this SAME issue with my MacPro I now know it's a particular irritant of Western Digital hard drives, which I am partial to and which are mounted in this Mac. So, that issue was not the Mac.
With regards to the SATA connection, yes - you'd have problems. A lot of drives are SATA 2 or SATA 3 and the PowerMac G5 official specs say the G5 is SATA 1. Finding a drive that will automatically scale down or has jumpers can be hard. That's not the G5s fault.
Lastly, as I mentioned earlier, I ran both the Quad and the 2.3DC full power, 24/7 for at least three full years. Not once did the PSU go. When I put them away they were both still fully functional.
So, either you had an anomaly or I had an anomaly. Either way, my experience with a Quad and 2.3DC was not at all your experience.