UPDATE: I have finally resolved my issue. Here's what I did in case others are having same issue.
I disconnected all HDD's sata cables (leaving power connected), except the SSD then in the BIOS I set the Hard Drive Mode to IDE, Disabled Native IDE Mode for ports 0-3. I installed Windows 10, after booting I followed the instructions of another forum member as follows;
1. Run Command Prompt as Admin
2. Invoke a Safe Mode boot with the command: bcdedit /set {current} safeboot minimal
3. Restart the PC and enter your BIOS during bootup.
4. Change from IDE to AHCI mode then Save & Exit.
5. Windows 10 will launch in Safe Mode.
6. Right click the Window icon and select to run the Command Prompt in Admin mode from among the various options.
7. Cancel Safe Mode booting with the command: bcdedit /deletevalue {current} safeboot
8. Restart your PC once more and this time it will boot up normally but with AHCI mode activated.
9. Bask in the reflected glory of being a total Windows 10 God
Upon rebooting successfully with AHCI mode enabled (still only SSD connected). I shutdown, connected 1 HDD, booted up fine, I connected up the second HDD it would freeze at AHCI BIOS iSrc v1.20E screen, so I disconnected that and tried the 3rd and it booted up successfully. With the power already connected pre-boot, I connected the 3rd HDD while in Windows. I installed the
Intel Chipset driver from Gigabyte website which updated the AHCI driver, I then checked the partitions with Minitools Partition Wizard and or some peculiar reason it was detecting the partition as a "Dynamic Disk" which was labeled foreign, so I converted it back to a basic disk, set it as active, applied and rebooted now all hard drives are connected up and the ssd of course. I hope that this helps.