An SSD is your best choice these days, but make sure to get a good one since many SSDs are low end budget economy models that can be as slow (or even slower) than a hard drive when writing large amounts of data.
Also be extremely careful buying hard drives these days. The most reliable hard drives from Hitachi have been discontinued. I honestly don't know which drive is the best anymore since I don't trust either Western Digital or Seagate. Toshiba started out using the same technology as the very reliable Hitachi drives, but I've had mixed results with some of the Toshiba drives.
Seagate started having troubles many years ago (around 2011) and have only recently started producing more reliable drives according to the reports released by BackBlaze. However, we found several brand new Enterprise class drives to have bad blocks almost immediately after starting to use them. Currently I've bought some Seagate IronWolf NAS drives for a RAID storage system since Seagate drives tend to run a bit cooler. Still too early to tell how they will perform.
I've never had much luck with Western Digital hard drives over the years. Sometimes they make very good drives, but other times the drives are just awful. There is no rhyme or reason. Plus Western Digital has been caught intentionally misleading consumers with their advertising by sneaking in new technology which saves WD money (but not the consumer), but at the cost of performance. The new technology is called SMR (Shingled Magnet Recording) which makes writing to a hard drive extremely slow! WD put this technology into drives where performance does matter without telling anyone about the change. You want to stay away from any hard drive using SMR except for very limited use cases.
Stay away from Desktop grade drives especially in a Mac Pro where you have multiple drive bays and lots of vibration. A NAS drive is better suited and should be more reliable. Be careful navigating the WD NAS drives though since they have three different variations on their Red NAS drive series plus there are some early WD Red NAS drives which secretly use SMR technology but are not listed as such (you must look at the product number to know which models use SMR). The best WD Red NAS drive is the Pro series which has a spindle speed of 7,200rpm. Stay away from the standard Red NAS drive as it is definitely using the SMR technology. The Red Plus (?) I believe is a variable speed drive up to 5,400 (maybe 5,900) rpms. Seagate has said they are not going to use the SMR technology in their NAS drives. I am unsure about Toshiba's product line as I haven't been purchasing too many hard drives recently.
You must be extremely careful buying hard drives (not enough competition) and equally careful purchasing SSDs as well (so many low end budget SSDs since consumers care more about saving money than realizing how poorly these budget SSDs really perform). The choice between a WD Red Pro NAS, Seagate Iron Wolf NAS, or a Toshiba NAS hard drive is about even. The Crucial MX500 series is currently a good middle ground on price/performance and reliability. OWC Mercury Electra SSDs are Ok, but I'm not a fan of them. Samsung EVO and PRO SSDs are much more expensive and unfortunately new models are starting to use TLC and even QLC NAND which is not as good (but allows for larger cheaper drives). Some Samsung EVO models have had compatibility issues with some Macs (not sure which models).