You have to understand that this test was designed to stress the drive to be utilized more than your typical work load, but I would feel comfortable saying with a decent CPU and GPU getting an SSD would at least run 1.5 times faster. If you have a 10yr old CPU, your not going to see any speed increase.
The random read and write specs are whats important here as the cache files seem to be just a ton of small files.
NVME SSD
you can see cache files are quite small and that 4KiB Q1T1 is about the performance you can expect for this drive to read these files.
Mechanical HDD
As you can see a mechanical HDD is much slower at reading these files.