Issue resolved after many tedious hours,
As suggested, the cable was indeed wrong. I measured the voltage of the cable I was using while the system was on, and the voltage was all weird, very different from another sata power cable in my other current working setup. After digging around I found...