What aspects of hardware of the core/storage make the biggest difference to Roon performance?

The recommendation for an SSD is for the OS and for the Rooon database. You don’t need and SSD for storage.

See this for more details from Roon.

https://community.roonlabs.com/t/suggested-hardware/90/20?u=brian