their reviews are amazing, I relay have never found a site as good as that for pro apps info and reviews from the hardware side.
it almost all windows but it will hold true to mac and we dont have the same CPU options all the time but from the articles, you can see how applications scale on GPU/CPU/drive speed or ram use etc
https://macperformanceguide.com/ used to be the best site but now it's just adverts
one thing to mention is what is your buget?
Mac Pro has 2x2.4 GHz Quad-Core Intel Xeon, 1GB 1066 MHz DDR3 memory, ATI Radeon HD 5870 1024 MB Graphics card, and three terabyte drives.
if thats what you use now then an mac min is going to be 2 times+ the speed (i7 cpu upgrade) maybe more
i think your CPU is the E5530 2.4ghz - 2.66ghz
if you want a cheep DIY upgrade,
two X5677 3.46ghz - 3.73ghz 4c/8t CPU are about £30 on eBay each
https://www.ebay.co.uk/sch/i.html?_...R1.TRC0.A0.H0.XX5677.TRS0&_nkw=X5677&_sacat=0
if your on a macpro 4,1 it needs the firmware 4.1 to 5.1 upgrade
only 1 GB of ram? i grabed 32GB on ebayfairly cheep was £50 a few years back
are your drives SSD's ?you can get 1TB SSD fairly cheep now.
GPU RX 580 8gb is a good option and will take you to osx10.14
but in the end id get a mac mini or imac with a i7/i9, DIY upgrade to 32GB of ram and have a new faster computer if it was me
ps
https://barefeats.com/ has speed comparisons of all the macs
imac i9 v cmp that is maxed out
https://barefeats.com/imac-2019-i9-versus-pro-macs.html
imac i9 v imac pro
https://barefeats.com/imac-2019-i9-versus-imac-pro-2.html
macmin2018 v imac and macbook pro
https://barefeats.com/mac-mini-2018-versus-other-macs.html