I run a RAID on my Server. RAID is great when you are forced to use Rotating magnetic drives, with their long dead times during seeks. For SSD drives, the payback is tiny, and the pain-in-the-neck-factor is still there. Any data error takes out everything with no survivors. Third-party RAID software is cranky, and MacOS refuses to install on a RAID-ed drive as a Boot Drive.
But since fast, cheap SSD drives have gotten much cheaper, I will be removing my RAID and using a single SSD drive. The extra hassle is no longer worth it for a few percentage points increase.
Today, where heat is a problem, a heat-sink is added, and you do not lose speed on modern drives. No need to mold your work around shortcomings in your SSD drives - most have been addressed and solved with proper heat-sinks. TRIM is required to avoid slowdowns, and must still be activated manually in MacOS, and I can provide an article if you like.
Your Mac Pro 2012, like mine, is dated. Its SATA bays can accept an SSD drive running SATA 6 G bits/sec, about 600M Bytes/sec. But that is nearly ten times faster that the fastest Rotating magnetic drive, and worth doing. The OWC drives come in a meal can, and do not have heat issues in those packages.
There is a bit more complexity in using the PCIe slots. I suggest you get a SATA SSD drive first, like the ones form OWC, and use it for a while. it speeds up everything, while allowing you to get used to the quirks of running off an SSD. They are cheap enough that it will be worthwhile, regardless of whether you continue to boot from it long-term.
Mac Pro 2012 PCIe slots are PCIe 2.0, and an x4 slot can provide at most 3500-ish M Byes/sec. Thunderbolt-3 connected drives [if you had ThunderBolt-3 ports] are limited to about 2500 M Bytes/sec.
OWC sells a single-device NVMe device card, and there is another popular one by Sabrent which fits an x16 slot like your Mac Pro top two slots, but as other affordable models only picks up x4 worth of data. Both have heatsink and thermal transfer pad in the box.