I would never go back to SATA II as my High Sierra boot drive, in fact there are now no SATA II drives inside my 4,1>5,1 cMP. I have been booting 10.13.6 from a Samsung 960 EVO M.2 formatted to HFS+ for about three months now.
Gilles & Dosdude2 ( and others ) have given us something that Apple in their wisdom saw fit to deny us.
The fact that 5,1 cMP's can install Hi Sierra & Mojave seems to say that some Apple engineers also too love the cMP and .. they appear to have been listening to our bug reports.
The Highpoint 7101A while still being expensive is definitely the way to go. I
WILL be getting one. I still recall paying AU$ 1,000 for ONE megabyte of RAM for my Amiga A4000T !
My current PCIe M.2 adapter yields 1389mb/s write & 1,480mb/s read . . that is way better then SATA II 100mb.sec any day and double the speed of the Sonnet Tempo. The only bottleneck I can see is having to transfer data from SATA II drives to PCIe AHCI/NVme M.2 drives.
EDIT : ( forgot to insert "M.2' )
PCIe M.2 to PCIe M.2 SSD's is the way to go.
Who knows . . we may soon be able to fully use USB 3.0 sooner then we thought.
In my current cMP setup ( see my sig ) I no longer think of my 4,1 as a 9 year old PC. It feels good for another 9 years
My next purchase will be a late model 5,1 cMP