SSDs are not worth it if your experience is limited to using them casually on desktops.
I disagree. My wait time on boot up is about 15 seconds, it used to be around 2 minutes. Return from sleep is instantaneous. I didn't think it possible, but upgrading to Windows 7 and a SSD increased my productivity drastically.
We're also going to see third generation devices in Q1. Personally, I don't know if the PCIe devices are necessary for a web server. If you're worried about speed, wait until the SATA III devices are out later in Q1 Sandforce 2000 series.
The most important advice I can offer is make sure your O/S and hardware can support the device. For example, you might not be able to boot from PCIe or your machine might not have a SATA III controller.
Anyone willing to use a 7200 RPM drive should feel comfortable with a MLC device. If you're really worried about writes, then go for SLC.
If you don't think they're mainstream, check out the offerings of hosts.