And, on the whole topic of reliability (a trending topic in the thread), here's a recent personal experience:
In my main HTPC I run my OS and apps off an 120GB OCZ Agility (don't worry - it's imaged regularly...) All of my media and other data resides on a Highpoint Rocketraid 3520 with six 2TB drives set up in a RAID-6 configuration. This is all housed in an Origen AE X11
case (yes I managed to shove 6 HDDs, one SSD, and an optical drive in that case - don't ask how and I won't have to admit it involved double-sided tape...). I also back up my most important stuff (personal photos/videos and data) in a variety of ways - offsite and to a USB drive attached directly (for a hopefully faster restore) via Crashplan, and offsite via pogoplug (my wife and I sync our photos and videos from our iPhones to the HTPC via Pogoplug). We also sync our phones independently to a Slingbox 500 with attached USB storage, and also a LyveHome device. I will add that while a loss of our personal data would be pretty devastating I'm not really that paranoid - most of my set up is more for testing and evaluating, for both my own personal use and my job. I will eventually pare down to a much simpler setup...
Here's the interesting/relevant part - about two weeks ago my very high energy two year old son ran pretty much full speed in to the entertainment center where my HTPC sits. The TV wobbled and my brain immediately assumed I was going to be replacing some (probably all) the HDDs. Fortunately, I am in the process of building a new system, in which I have 12TB of storage (software RAID0 for now, but don't worry - just for testing. Still working out my new storage plan...) available on, so I immediately sync'd everything from the HTPC to the new storage. Sure enough I've had the array rebuild itself twice since then, with two drives failing both times (what's weird is neither drive show any SMART errors, and the array managed to rebuild itself both times on the same drives, and has been running merrily for about two days now. Not exactly sure what failed, but the drives are getting replaced anyway). My saving grace here is that I JUST upgraded from RAID-5 to RAID-6 three weeks ago, else I would have been re-ripping a whole bunch of stuff and lost a bunch of TV recordings... In any case, after this happened I had pretty much zero concern about the SSD after the impact.
The tl;dr version of the story is if your HTPC is in a location where it could be bashed by a two year old, and you only have room for one storage device, an SSD may be a better choice.
Oh yeah, probably should've mentioned my son is fine... He really was my first concern after the crash. Really. I swear.