Unless money is really tight or
you absolutely need a bootable SSD I wouldn't consider anything that is not PCIe M.2 based. The gain SATA-III offers over SATA-II isn't worth it. Thus this recommendation eliminates the card you referenced (which, as someone else has already pointed out, is crippled providing only ~ 80% of the SATA-III theoretical speed).
PCIe M.2 based SSDs provide significantly more bandwidth than SATA based SSDs. If file load times are an issue then an M.2 based SSD will make a noticeable difference with some offering ~ 2GB/sec throughput (versus SATA-III's max 600MB/sec throughput). They currently come in two variants:
- AHCI - More compatible but lower speed (offering around 1.2GB/sec throughput)
- NVMe - Less compatible but higher speed (offering around 2.1GB/sec throughput)
For the Mac Pro AHCI is what I would consider the sweet spot for compatibility versus speed. There are some AHCI PCIe cards which can boot in a Mac Pro. I am not aware of any NVMe based PCIe cards which are bootable in a Mac Pro.
My recommendation is to separate the boot drive from the scratch / data drive(s). At least for the drive(s) which you'll be using for your video editing and consider an NVMe based PCIe card. If you wish to use the drive as a boot drive you're only option, that I'm aware of, is to use an AHCI based PCIe card. With a throughput of 1.2GB/sec they offer fast performance while also providing the flexibility of being bootable.
Any solution should be researched to ensure it is compatible with your model Mac Pro. This is especially true if you want it to be bootable. Others have provided specific models to help you out. I've never dealt with a PCIe M.2 solution for my Mac Pros but I do have an AHCI based PCIe M.2 HP Z Turbo drive in my Z620 system and I love it.