HDDs wear out too. The liftime of an SSD are just way more deterministic then the lifetime of an HDD. Also reading is way easier on an SSD then on an HDD. (No moving parts and the cells get basically not touched much) SSDs too are meant to overwrite write and read data or do you use a HDD as a data cache?
If noise is a big factor then SSDs are the easiest choice. But they are way more expensive compared to high capacity HDDs(16TB+ are going for less then 15€/TB) When conparing low capacity drives like 4TB then the price for an 4TB SSDs is not too outlandish(still hgher)