I have read too, though I don't have any personal experience using one, that over the long run an SSD isn't a good choice if you do a lot of write/delete type activities as the storage can have a limited compared to HDD number of changes to each spot before it can start showing errors.
I use HDD to store movies/TV and don't have issues with running slow or waiting when playing.
Most modern system OS's are already doing a huge amount of write/delete functions as part of their by the minute background operations, creating and rewriting temp files, log files, swap space, etc. Original SSDs (and USB sticks for that matter) had a very big problem with the write fatigue syndrome, because an SSD memory address can only change state a finite number of times before it becomes unstable. Newer devices work around this by rotating the writes across the entire device so one section isn't getting constantly hammered. This increases the useful lifespan but its still not infinite.
In a fixed environment (desktop machine that doesn't get moved around, good climate control and miminal dust/dirt) a rotational drive may well be more reliable than an SSD. I've had some that were over 30 year old still function (and yes I immediately made backups of them). The downside is it only takes one not-alltogether-hard shock or shake while its running to turn a rotating drive into a paperweight. I know people who had their laptop drives ruined just by moving it from one table to another too aggressively, and normal airline turbulence can kill one too. Plus they can be noisy, and they do generate heat.
SSDs are ideal for laptops or other devices that get transported around - until you slam it hard enough to physically break the circuit board it doesn't care about rough handling. They tolerate dust and heat better as well because there are no moving parts, and generate less heat/noise as well. They also draw less power so help with laptop battery life (also handy if you're sticking 5 ot 6 devices in one desktop machine too). Getting an SSD that is substantially larger than you really need will go a long way towards extending the lifespan because there are more memory addresses for the write cycles to be spread across. The closer to filled the SSD becomes, the fewer open spaces there are for the onboard firmware to use for rotating out the writes. Hard drives eventually can hit a similar limit but usually it manifests as overwritten sectors if you get too close to 100% full rather than a read/write failure due to a physical flaw.
Speed wise SSDs perform much faster when accessing many small files in quick succession, because there is no "seek" time required to move the heads from place to place. For large files the difference is less. Which is why booting up from an SSD is almost always faster than a rotational drive.
I use SSDs pretty much exclusivelly these days because of the speed, lower power requirements and toleration for less that ideal environment factors. I've seen one or 2 go non-responsive or unreliable, but they were older and smaller units that didn't have very good write cycle management. Also making sure that you host OS supports the SSD trim modes is important, because that is part of the write cycle management.