1. Based upon the description in your original post of the problems you've been experiencing it doesn't sound to me that the culprit is a defective PSU. Like anything else in this PC world it could be, of course. If the PSU is suspect the ONLY definitive way to determine such is the obvious one - another (presumably non-defective) PSU must substitute for the suspect one. You should do so with that PSU you also have available.
2. It's hard to imagine if it was a problem with the PSU you would have experienced "a whole bunch of hard drives fail on me one after the other". I just can't see how one would lead to the other.
3. I don't understand your comment that you "suspected the sata card, but I've replaced that 3 times now also". What SATA card? What precisely are you referrring to? Each drive in your system is connected to the motherboard's SATA data connector (port), are they not?
4. If I had to guess - and it would be only a guess - the problem is a defective motherboard or possibly another major component in the system, e.g., the CPU, memory, etc. But this is only a guess.
5. In lieu of running around in circles to change this or that component, at this stage of the problem there's really only one thing you can do. Start over.
6. Rebuild your system "from the ground up" as it were.
7. The basic approach would be along the following lines...
A. Get inside your desktop computer case (after disconnecting the A/C plug from your wall socket) and determine that the CPU, heat sink, memory modules & graphics card are all properly seated and all connections appear secure. Remove (disconnect) ALL peripheral devices including ALL HHD & SSD drive(s), optical drive(s), sound card, etc. Disconnect ALL storage devices, printers, and any other devices connected to the machine.
(As an aside, if it's not too onerous, it would be even better if your would remove the motherboard + components from the case and work with it outside of the case - perhaps on the cardboard case the MB was packaged in if you still have it or some other non-electric conducting surface, e.g., cardboard, wood, etc.)
B. In any event, all you'll be working with is your motherboard, processor, heat sink, RAM, graphics card, power supply, keyboard & mouse. Better yet, should your motherboard have onboard graphics capability, disconnect your graphics/video card from the system. Just ensure that following access of the BIOS/UEFI interface, if there is a BIOS setting for onboard graphics display that BIOS setting is enabled since that setting is frequently disabled as the default setting.
C. Reconnect your A/C cord and power on the system. What happens? Do you get a "normal" screen display? No error messages or strange notations from the system?
D. Can you access your BIOS/UEFI without any difficulty at this point and review the CMOS-BIOS settings? In particular, ensure that the SATA controller mode is set to AHCI (which should be the default setting). Check the hardware monitor/PC Health in the BIOS to determine that all temps are within normal range?
E. Assuming all is well at this point leave the system powered on for the next hour or so, checking to see if anything untoward shows up. Using your reset button, try powering down & up a few times to determine if there are any problems there.
F. Now you can install your graphics card in case it hasn't as yet been installed.
G. Along the way of the above steps if there's any indication of a faulty PSU, test that component with a PSU power tester (assuming you have one) or better yet, substitute a known non-defective PSU should one be available.
H. Should all appear well at this point this is an indication that there's nothing wrong with the basic components of your system. While not absolutely definitive this is so, it's a very strong indication that something else is amiss.
All this, of course, is to rule out at least to some degree) that the problem is not hardware-related insofar as the basic components currently installed in the PC.
Finally, install any BIOS update.
8. At this point install your boot drive in your system and boot to the OS. Hopefully the system will boot & function problem-free. Work with the boot drive as the ONLY drive installed for some time to determine no problems exist.
9. Install your secondary HDDs (one at a time) and similarly work with the system to determine all is well.
I just don't see any other practical series of troubleshooting steps at this point but perhaps you have some other ideas. In any event keep us apprised of your progress (or lack of!). Good luck.