I bought an OCZ Vertex 120gb for around $350 or so in time for the shipping of Windows 7. I installed Win7 on it, and the various applications I've got running on this machine, including Aces High. The boot time is speeded up quite nicely, as well as the application load times. My computer is running a 4+ year old chip, so it's not the speed demon it could be with today's latest and greatest cpu tech, but with this SSD it still feels nice and snappy in the user experience.
As has been mentioned, the wear-leveling and whatnot make the whole "you can only write to it so many times" thing really a non-issue. Most of us would probably take a few years longer to wear this thing out than we're likely to be using it at all - in five years, won't we have upgraded to something even larger and faster? I rather think so.
If $350 is out of one's reach at the moment, then OK, wait, this isn't going to make anyone cream their jeans or anything. Certainly don't let your family go hungry so you can buy an SSD. But if one has the $350 or whatever and wants to spend it on toys for their computer, the SSD is a good one. I am very happy with the OCZ Vertex.