Here are the problems with your planned SSD:
1) Despite the NVMe and PCI-e support, the sequential write speed of that SSD is no faster than that of a SATA 6.0 Gbps SSD.
2) Without knowing your particular aged PC, your PC might not have m.2 support at all natively. And if you get a PCI-e adapter card for that SSD, your system's PCI-e slots might be only PCI-e 2.x compliant, which means that you might not achieve anywhere close to even that SSD's rated sequential read speed.
3) If you instead choose to abandon that SSD idea, and instead you choose a SATA 6.0 Gbps SSD, you may find that you don't have any available SATA 6.0 Gbps ports - but instead all of your PC's available SATA ports are only SATA 3.0 Gbps, you will not achieve even the rated sequential speeds of the SSDs themselves (which means that the maximum sequential read and write speeds of any SSDs will be limited to only 270 MB/second even if they are capable of over 500 MB/second).
Thank you for your reply. I most certainly need help verifying my hardware before purchase.
While the configuration of my PC will determine whether the above listed hardware will work, I didn't ask about the hardware configuration. Let's leave that for later.
As the title of the thread lays out, I am asking about cache vs raw files (files from cam).