Got SSDs and tested. My conclusion is here.
So,
With HDD and maybe 4GB for dbcache, 2 to 3 weeks in 12 hours. GUI stalled badly.
With HDD and 16GB for dbcache, 5 weeks in 2 to 3 hours. GUI still stalled badly I think.
With SSD and 16GB for dbcache, 2 weeks in less than one hour. Maybe less than 30 minutes? And GUI felt less unresponsive.
Roughly, 10 times speed increase with bigger dbcache, another 2x increase with SSD and same dbcache.
My benchmarks aren't equal because I didn't have much blockchain left when I got RAM and SSD upgrades. But roughly.
With Monero,
RAM upgrade didn't help.
With HDD speed was 500 to 600 blocks/h during the final 50000 to 100000 blocks.
With SSD, speed was around 5000 blocks/h, a bit more or a bit less at times. So 10x increase in speed.
A year ago perhaps, when I benchmarked file systems, I got over 5000 blocks/h on HDD. Up to 9000 blocks/h at times. But Monero has some kind of checkpointing that speeds up syncing I think? So these cannot be compared to today's results?
It must be said that this computer is not new, and my cryptocurrency stuff are running in a virtual machine. The disk is passed to the virtual machine and I don't know how much overhead this brings.