I'm about a month short of having owned SSDs for 'over 3 years'.
The drives certainly do give older/less powerful machines quite significant leases of life. I first put a 96GB Kingston SSDNow V+100 into my Nehalem i3 ThinkPad (i3-380UM) which has 8GB RAM. The performance gains were outstanding in comparison to the 250GB 5400 RPM drive that it came with as well as making it quieter and giving it slightly more battery life (although this was may have also been attributable to a fresh Windows 7 installation).
My desktop is very old (Core 2 Duo E6400 Conroe 4GB RAM) and had 2x250GB 7200 RPM in RAID0. The data was moved onto one of these and the other was replaced with a 128GB Crucial M4 which held the OS and applications. This did make fairly a massive difference to loading times of both the OS and the applications I have installed, especially the heavier ones such as Photoshop. I did find that opening large files (such as RAW images) was still comparatively slow (worse still because the drive was no longer in RAID). In an effort to improve this large file access, I eventually replaced the 250GB data drive with a 256GB Samsung 830 SSD (only because it was the cheapest 256GB drive available at the time) which did improve performance fairly significantly.
My desktop boots up in seconds and large applications such as Photoshop now take less than 7/8 seconds to start (down from 15-20). I would thoroughly recommend an SSD to anyone for any desktop, laptop and workstation computer. The performance gains will vary depending on how performant the machine is, but there will always be some compared to a spinning platter drive. SSDs are especially recommended for laptop because they usually come with more energy efficient hard discs which are slower but also potentially prone to damage through significant vibration (although in about 15 years of owning laptops, this has never happened to me).
I have never had to RMA an SSD I have owned (I still have them all).
I have also put 64GB Crucial M4's in other machines. My parents-in-law's laptop (Dell Lattitude D620) and also my HP Microserver, as the drive where my ESXi installation lives and certain VMs have their datastores in an effort to improve performance.
I think the days of complete horror stories have gone and that SSDs have now hit that minimum reliability threshold such that they can now be considered a mature technology. I would recommend anyone considering one to stick to one of the recognised brands (Crucial, Samsung or Intel) as I have heard nothing but good things.
Experiences of others of brands such as OCZ (now part of Toshiba, at least in name), whilst they were trailblazers in the performance stakes at one point, have suggested that they are either great or appalling in terms of reliability. The voices of the vocal minority are often amplified on the internet so I don't know how much credence to give to the volume.
The price of SSDs is also tumbling, with bigger drives now giving the best bang for the buck (price per GB compared across a range). I think it shouldn't be too long before the sub-$200/£200/€200 1TB SSD comes along (currently around £340 in the UK).
Sorry for the long post...