For what its worth, I have been using SSD's for about 3 years now, on Zorin 9 11 12 and Linux Mint 18 and Windows 10. I also had many questions about write cycles, Trim, Swap, over provisioning and so on. In the end I just bit the bullet and went for it. I just do a 'Default' install, 'system' and 'home' on one partition with about 4GB swap onto 64GB and 120/128GB SSD's and mSATA SSD's (mini SSD's in Micro PC's) across 5 different machines.
As far as I know Ubuntu (+ derivatives like Zorin Mint etc) from about 16.04 (don't quote me on that) run 'Trim' automatically about once a week in the background. On Zorin 9 (14.04?) I would run it myself from time to time but now on Zorin 12 and Mint 18 I don't worry about it. The command I ran was: sudo fstrim / -v and this was on ext4 partitions. I just don't even think about it anymore.
The first SSD I got was a Samsung Pro 128GB with a 10 warranty for about $140 AU. I also go a 1TB HDD for around the same cost around that time so cost per GB difference was enormous but the speed difference was also, my boot time after 'POST' screen went from about 60 + seconds to 12-15 seconds, enormous also. I also have some other brand SSD's at cheaper cost/size. Any large files I save to a NAS or HDD's.
The way I see it, by the time these drives are spent the cost difference will be closer and/or newer technology arrives, meantime I really enjoy that speed especially when booting up.
My 5 year old 2TB HDD recently died and $90 AU replaced that. I looked at smart data and self tests in the "Disks" utility and it had about 1 year and 4 months of 'up time' on it at the time it died. My Samsung SSD currently has about the same 'up time' with no 'failures'.
If the cost isn't an issue a 'large enough' SSD for your OS and HDD's for storage is the way to go, or 1TB SSD if you have a pile of cash burning a hole in your pocket. Time will tell but I expect my SSD's to last for some years yet, even if they start failing I would still replace with SSD again (or M.2/NVMe) as the cost has already come down from when I first purchased mine.
I suspect there is some confusion, mis-information, lies, false beliefs and so forth around these devices, I am most happy and would add that short of a new PC, SSD's have been the single largest performance improvement I have ever experienced from an upgrade.
Also, there are other things to consider, reduced power consumption, shock/impact resistance, weight and temperature reduction, especially for notebooks, space, noise, no moving parts...
I love SSD's what more can I say, cost per GB compared to spinning HDD's is, for now, the main question imho.
A screen shot of my Samsung 850 Pro self test data.