Hi!
If you are using the standard cloud providers, then you can use block storage like gp3. Else SSD all the way.I wouldn’t recommend HDD for normal workloads, only for cold storage. It works though. 
We’ve also recently updated the storage & filesystem section of the capacity planning guide. Check it out: Capacity planning | QuestDB