I still don't have any hands-on experience, but I found a few interesting things about them so far (aside from the obvious that they are completely silent & bloody fast). Most of them are lifetime / endurance increasing tips.
- The serious wear related issues they had a couple years back (the 'bits' on these discs lose a tiny bit of charge every time they are rewritten) have all been resolved. How you use them still affects their lifespan, but it is already generally accepted to be as long as a regular HDD's, if not longer (it would still depend a lot on the price class of the SSD in question). It's still wise to keep a 'normal' HDD drive around for programs that do a lot continuous of writing to the disc's surface (not usually games, but likely download managers, torrents and other programs that continuously download, such as Spotify and general browser cache).
- For this same reason, you may want to relocate the Windows Pagefile to a normal disc. Also if you like to hibernate your Windows sessions a lot, it would be a good idea to relocate the space it uses for that to a different disc too. (MAJOR edit: Doing the opposite by putting your pagefile on an SSD file will severely speed up Windows, so maybe you want this if you trust the durability of your SSD enough. In fact, I believe Windows ReadyBoost will automatically ask you to do this whenever you connect a Flash or SSD drive.)
- The standard Windows NTFS filesystem is too cumbersome for SSD drives. SSD's should instead be formatted [url='http://en.wikipedia.org/wiki/Exfat']exFAT[/url], to further reduce wear from unnecessary writes. However..
- Sadly Windows cannot boot from exFAT yet. Another reason to keep a regular hard drive around, just for the time being. Some Linux distros can boot from it, but they may still have general issues with exFAT (seeing as how exFAT is primarly a Microsoft product). Linux may have come up with something better anyhow.
- I have heard of hacks that will let Windows boot from exFAT. Unfortunately I have no links to these as I question their legality. Use them at your own risk.
- Getting several smaller SSD drives may in some cases be better than getting one, big drive. The reason for this lies in the architecture of the disc itself. Large and small SSD's occupy the same physical space (to fit in your motherboard) and hold the same amount of electrical charge to keep all the bits and bytes in place. It also means that there is less charge per bit available on larger, higher density drives. Less charge will ultimately evaporate faster during writes.
- Don't buy low-budget SSD drives. They are just as fast or sightly faster than the best 'normal' hard disc drives, but much more expensive. Unless the noise factor is an absolute seller for you, the cost-benefit ratio of low-budget SSD drives just doesn't work out.
- To older and simpler motherboards an SSD drive will likely be the fastest component. In such cases, every time it tries to read or write it would need to wait for the rest of the system to catch up. Even if you notice a speed increase, getting an SSD drive may ultimately not be cost effective enough.
- New SSD's should all have this but just in case you aren't sure, look for drives with [url='http://en.wikipedia.org/wiki/TRIM']TRIM[/url] support to further increase SSD endurance.
Edits:
12-17-2012: Extended 2nd point about pagefiles.