I think a system with 32 GB RAM and HDD could be faster than the same system with 8 GB RAM and NVMe

yeah a wd gold 8tb hdd is fast enough with a good cpu and ram of
...
Ram is a big deal
I guess both of you assume that the
dbcache will be adjusted accordingly, otherwise I suppose 8GB vs 32GB doesn't make a difference, if you only use 600 MB of it.