Cloud backup options & HDD / SDD for long term data storage

Hello

I am going through multiple old hard drives with photos, home videos, docs etc and more recent SSDs.

They plan is to collate what I want to keep, backing up to the cloud and also have at least two local physical hard backups but stored off sight and not at our home.

I can't see it being any more than 10TB in total. Have been thinking of Backblaze as two PC user friends use them. Also, for longevity, is it better to store local backup data on HDD or SDD. My thoughts were SSD as no moving parts so less likely to fail?

Appreciate any help.

Many thanks

Matt