I've been all SSD for about four years now, for both sample storage as well as project and audio drives. At first I was using some of the OWC drives because they were first out of the gate with 1tb (actually 960gb) capacities, and I have four of those in my old silver Mac Pro 12-core tower.
When I moved to the Mac Pro cylinders I got a pair of the BlackMagic MultiDock v2 units, and they're filled with Samsung 850 drives - at the moment it's six 2tb 850 Pro drives and two of the 4tb 850 Evo drives, since the Pro series is not available in 4tb capacity yet. The speeds of the Pro vs Evo drives are basically the same - but they do use slightly different underlying technologies that, in theory at least, make the Pro series more durable in terms of total amount of data writes before failure. I believe the warranty on Evo drives is three years while Pro drives is five years? Not sure, but never had to make a warranty claim, so... check their website.
If you want single external drives, the Samsung T3 drives absolutely rock, are ridiculously small, connect via USB-C to any computer with Thunderbolt or USB jacks of any flavor, and are basically an 850 Evo drive in an external box that's half the size of an iPhone. They come in sizes up to 2tb and are priced about the same as the "bare" 2.5" SATA versions that I use in the MultiDocks. My wife has a pair of the 2tb T3 drives on her iMac and they are great.
In practice, you'd have to be basically filling the entire drive, wiping it, and re-filling it every day for years before you'd get anywhere near the limits of the drive's durability in terms of write cycles. In normal use, a drive used for sample storage will be 90% reads and only 10% writes, or something like that. My 4tb Kontakt library drives get big chunks of data written to them only when I've just bought and downloaded a new library, or in tiny amounts when I edit and re-save a Kontakt Instrument file.
My use cycles on the "raw samples" drive that I use for loops and other stuff that gets dealt with in Ableton might see a little bit more writing, with Ableton constantly writing those tiny little ".asd" files, as well as me bouncing, processing, etc. on the audio files, but still... it's a tiny fraction of the total durability of the drives.
The growth in mechanical hard drive capacities has slowed somewhat - a few years ago it seemed that every six months the drives were twice the capacities for the same price, so I wound up buying bigger drives LONG before I "wore out" the older, smaller ones. With the rapid growth in the SSD market, it's sort of that same situation now - you might buy a 1tb drive today and in a year's time the 2tb drives will be the same price - plus you'll have filled that 1tb drive, so you'll probably be upgrading to a larger size LONG before you get anywhere near the durability of the drives.
Just be sure to always keep current backups - I use mechanical drives for this since they're so cheap by comparison: for $600 you can get a 10tb (!!!) spinning drive that will hold all the data from five 2tb SSDs that cost a total of $3,700 (!!!). When an SSD dies, it just goes away instantly and completely (so I've heard) and no "drive savers" data recovery service can get a single file back from oblivion. So back up.
These days I go with Samsung drives exclusively, since they have the largest manufacturing capacity, the most experience, and the highest number of drives out in the field by a large margin. They are just owning the market lately. Some other manufacturer's drives might have slightly lower prices or slightly higher speeds, but Samsung is "the market leader" and they're ahead of the curve in terms of pushing new technology for the memory chips etc. They're stable and reliable. I have had zero failures across more than a dozen Samsung SSD drives in the last few years. I do not baby them, use third-party "trim enabler" software, or do anything other than format them with the default settings in the MacOS Disc Utility software - and then I beat on them mercilessly with no regard for "oooh I better be careful about how much data I write".
The water's fine, come on in! Just don't go for the el-cheapo drives and make backups.