Depends on the usage and environment. In the (good environment) worst case an SSD can have a TBW rating 10 times less than a hard disk. See post #6.
Hey Guys! Might be a stupid question but can I use a SSD drive as my main external for storing and editing on? I heard they aren't as reliable in the longterm versus a tradinaly mechanical drive? I will keep be keeping my 200 gig music library, 1.5TB home movies and 300 Gig Lightroom library...
forums.macrumors.com
As for HD reliability by vendor, see the latest Backblaze disk report:
We take a look at the Q1 2020 and lifetime performance of 129,764 hard drives used in the Backblaze data centers.
www.backblaze.com