Could you give examples of suitable workloads for HDD and SSD
Workloads that involve lots of writes and especially rewrites, transient and ephemeral data, don't require low latency or fast random access, money is a factor: HDDs.
The key thing is that HDDs have a theoretically infinite amount of writes compared to SSDs which have a finite amount. Certain workloads are consequently going to be more suited for HDDs.