The long and short of it: Avoid OCZ. They have terrible QA, so they have roughly double the return rate of other SSDs. Most drives also tend to have firmware problems that are discovered at some point, then fixed. So update to the latest firmware as soon as you get the drive. In general, the percentage rates of early disk failure (DoA or early-life failures) are similar to platter disks, so any SSD you get should last you at least a couple of years.
As for long-term durability, the drives can write a ridiculous amount before they die.
These people here are running an ongoing test where they constantly fill (most) of the drive with random data, erase it, and fill it again as fast as possible, trying to measure how long the drives last before they die. A lot of the drives are managing close to a petabyte (1000 terabytes) before failing. Even if they "only" manage to write, say, 500TB, that's enough to completely erase and fill the entire drive every day for almost 6 years (for a 240G drive), or ~11.5 years (for a 120G drive). In reality, unless you're running it as the cache drive for a database server, you'll be writing a lot less than that.
Finally: Flash memory needs to be renewed periodically. If you're planning to take the drive out and store it in a drawer for months on end, don't use one. JEDEC specs state data should last a year on the drive without power, but I wouldn't trust that 100%. If you're using the drive at least once every couple of months or so, this is a nonissue.
In short:
Don't worry about long-term death.
Don't buy OCZ.
For higher performance (likely not noticable, the difference isn't massive) get a Corsair Force 3. There is an ongoing problem with these causing Blue Screens - they released a firmware update that apparently fixed it, but I've heard reports of some drives still giving them, if a lot less frequently.
For higher reliability (better QA on the firmware, more testing done by the companies) get a Crucial M4, a Samsung 830 or an intel drive. Samsung and intel are more expensive, and the intel drives are slower, too. The M4 will need a firmware update, or after 5184 hours of use it'll start crashing your computer every hour.
I have a Crucial M4 in my desktop, and a mSATA intel 320 in my SFF box. It makes a huge difference to generally usability - logging in to windows takes a couple of seconds and then everything is usable, booting is short. Programs open instantly, and close just as fast. Using my laptop is now annoying enough that I avoid it unless absolutely necessary. Once a game is actually running it doesn't make a difference, but it cuts load times significantly on a lot of games, and makes a huge difference in WoW specifically (since it loads stuff dynamically as you run around). Really, though: The main reason I love the SSD is not games (I can live with the occasional loadaing screen), it's more that everything I do which isn't a game is more pleasant.