I found spinning rust to at least give some clues prior to a crash and burn.
You know, I find this attitude to be both prevalent, and strange for supposed IT experts. Most of your computer doesn't run on "spinning rust". CPUs, memory, motherboards, power supplies... nobody says the lack of noise they make when they die (unless you count the screams of the souls that are released with the smoke) is a problem... but somehow, when it comes to SSDs, the "I can hear it dying" argument comes up. A lot.
I suspect this is a psychological attachment, with a healthy helping of overvaluation of personal experience instead of objective data. The weird part? When you point it out, geeks tend to dismiss it as "Well, they just aren't as good" as though 'goodness' was some kind of objective measure. I find this all the time amongst otherwise perfectly rational IT people: The belief that because the solution isn't perfect, it is therefore wrong, while ignoring the fact that the current solution they're supporting is also not perfect.
But the fact is, SSDs are many multiples faster than regular old "spinning rust" and more reliable. Ask any major manufacturer what their average warranty RMA rate is on their SSDs versus any other manufacturer's RMA rate on regular old "spinning rust". You'll find that SSD manufacturers regularly offer 3 and 5 year warranties. You're lucky to get a 90 day return policy on spinning rust bought off Amazon.
Now, all that said, dig into the data and you will find some new failure conditions that spinning rust doesn't have. For example, sudden power loss can cause a temporary loss of capacity, which will show up as bad sectors, in many SSDs. Very few IT professionals are aware of this; Or the fix: Physically disconnecting it for at least an hour, then wiping it (SATA command, not OS) and restoring the data. Many will RMA a drive claiming 'bad sectors' when there's nothing physically wrong with the drive... it's just buggy firmware.
Everyone points to write-exhaustion; The overly-focused on issue of repeated writes eventually 'wearing out' the drive. But guys... the average cycles here are 3,000 to 5,000 per cell. If you are writing 10GB a day to your drive, then a tiny 80 GB SSD will take 18.7 years before it gives up the ghost; Or about 68.5 TB of data written to the disk. If you opted for a 160GB drive, kick that out to 37.5 years. And that's for it to start showing physical loss of storage capacity.
The problems of SSDs is not electrical. It is not physical. It is entirely software. The firmware on many of these drives is buggy and this is covered up by the SATA / AHCI interfaces, which were designed for spinning rust, and thus have no direct way to signal the myriad of weird firmware glitches.
The electrical/physical part of SSDs is proven tech. It doesn't go bad, not under the usage conditions that the average computer user will put them into. And yes, I know, you don't think of yourself as average... but you are, ok? Even you, Mr. Programmer, Mr. Video Editor, and Mr. Super Linux Power User ZOMFG I Built My Own Raid In Mom's Basement. All of you are the 'average' case. The only time I've heard of mechanical drives being preferred is in usage conditions where data is being constantly written out -- such as a monitoring system like the Large Hadron Supercollider that collects terabytes upon terabytes of data, which is then processed and flushed, many times a day. SSDs would be bad in that environment. But unless you're building your own LHC in the garage... SSDs will work just fine.
That said... I have considered writing to OCZ and Intel and asking them if they could make their SSDs make the same noises as mechanical drives. There's a proven psychological value in this; Just like how your cell phone camera is programmed to emit a shutter snap sound... despite shutters not being around since the 80s. Because there are a lot of people that apparently need reassurances that their computer be making noise in the corner for them to feel good about it's performance and reliability. It may be too soon for geeks to live with silent computers.