The technology has been totally overhauled thanks to everyone's paranoia with limited writes. A quality SSD can compete with mid-ranged HDDs for lifespan.
*However*. Configuring an SSD and the computer to use an SSD is a non-trivial task. This is absolutely not something for an everyday consumer. The wrong SSD will perform worse than a HDD and requites heavy lifting to get it to work well. The right SSD will perform very well, but could still use lots of tweaking to get to work even better. It's because of the time and skill required that I wouldn't recommend an SSD to most people. However, an SSD has been fundamentally game-changing for me with running WoW, and it would be an absolute improvement over using an HDD when doing recording.