Just don't get a cheap one as some aren't that quick. My RAID 0 array benchmarks higher than a couple of the OCZ ones.
Only for moving large files around, which given the capacity of the average SSD, evidently is not the point of them at this moment in time.
I have recently purchased the Intel X25-M after months of deciding. I chose it because of the great reviews and overall speed. The write speeds that let it down make absolutely no difference to anything, so don't be put off by that, it's the seek time that is amazing.
I have upgrade my PC to what is below from a Dell Inspiron 1525 laptop ( 2Ghz core 2 duo, naff graphics etc, and windows vista ).
I can honestly say that after building this computer ( bit by bit )... the new SSD is the biggest performance boost yet. I spent more on the processor ( I7 920 ), and that improvement didn't give even as much of a boost as the new SSD.
Think about this, because it sounds like you use your computer for the same things as I do,.. i'm a student, and have about 2 games which I play ( not too often ).
You boot up your computer, and want to start up your browser, and maybe MS word and put your music on. All of these are things that are literally instantly opened ( maybe not the music if you store it on another HD, but at least that HD is free to do only one thing ). Every time you do anything that requires the HD, opening your game, any files... snap.. it is literally, INSTANT.
The only time you will see loading bars is likely to be processor heavy tasks, such as un-rar-ing. etc. Most of the things I do on my PC are now super fast.
As far as game loading times, they no doubt will be faster, but I only have one game on mine which I never had on a HDD, so I wouldn't know the exact extent to which it improves. I have Napolean Total war ( 18gb! ) on mine, and it loads up pretty fast.
P.S The intel x25-m also shipped with the latest firmware, including TRIM, making it a pretty hassle free installation ( apart from my bad windows DVD but hardly the SSD's fault ).