Update 9/10/23.
OWC Accelsior 8M2 arrived on Friday. Opened up the Mac Pro and seated it without issue. On boot up it recognized the drive right away and the SoftRAID setup was a piece of cake and it runs in the background unobtrusively. Been copying over large data sets from old computers onto it at very fast speeds. Only quirk is that in the finder window, it shows up twice. Doesn't affect performance or functionality, from what I've read this is a known and widespread bug with OS X Ventura. No big deal.
2 monitors are up and running with the Mac Pro under the desk. Right now I have a Mac Studio Display and an Eizo Coloredge CG2700X running side by side. One slightly annoying thing was I had to spring for a 1.8M Thunderbolt 4 cable to get the monitors oriented on the desk the way I wanted. That sucker was not cheap ($129)...
Overall, it's a sweet setup, very pleased and no issues to report!
Do I regret not saving some money and having a Mac Studio sitting on my desk instead? Speaking for myself, no.
That's about it, appreciate everyone's thoughts and assistance!
This is the kind of use case the 2023 Mac Pro is for, it's not for every body.
I just hope Apple allows for larger RAM options + PCIe GPU support in the future.
I have a feeling they will, they just had to go this route this time.