Ok, another good news bad news situation! I GOT IT TO WORK! ONCE!! lol
So here's what I did...I decided to try my computer one more time in its original configuration (SSD Home drive in PCIe slot, Time Machine HDD in SATA slot 1, HDD Mass storage HDD in SATA slot 2) and fired it up. It worked! I thought it was the fact that I removed that High Sierra boot drive from SATA slot 1 that might have been interfering. I then shut it down and tried to reboot just to see if it would work again. NO success. Tried a few times along with a SMC/PRAM reset to see if that would help, but no luck. It would appear that the Apricorn Velocity Solo X2 PCIe card just doesn't want to play nice with the Sapphire Pulse RX 580! And according to the link from
@crjackson2134 above, other people are having this issue as well. However in their case they are running Mojave and I'm still on High Sierra, but I guess that doesn't seem to be the only issue....
So in order to get my MP up and running again, I figured I'd put the SSD in the empty CD/DVD SATA slot (where it had worked fine before), left the two HDD where they were in SATA slots 1 and 2, and fired it up. NO GO! I tried one on its own, then the other, to see if it was the drives (both are fairly new 8TB HDDs, one is a Seagate Barracuda Pro, the other a WD I shucked from an enclosure). Then I tried each one externally (using the SATA card from the shucked enclosure), and each one worked!
So this is really got me baffled....the fact that the SSD did work once with the PCIe card, and now won't (which I can live with until I get another PCIe card that WILL work), and the fact that the only way I can get get my computer half working is with the SSD in a SATA slot, and the others only externally??? Any idea how I can get my HDDs to work internally again? Thanks!