They make the same amount of nosie as your system RAM does
I've read allot articles from Hard-Core gamers about disk drives, and in some circles the serious gamers sill prefer IDE over SATA even, I dont really get that one though.
Performance wise, I've not seen anything that will top 15K SCSI drives yet, but with the advancement in SATA2/3 controllers & drives, SATA is making a seriuous run at SCSI.
I dont think I would put one of these SSD's in a serious workstation or gaming rig, for many reasons, performance being only one, however, in a Laptop, Embedded Solution, or even a PXE boot situatoin, I think they make the most sense.
If Read / Write speed performance is what your after, then the SSD's aren't quite there yet, but they will be in the not to distant future.
The performace gained v.s. the cost to get it jsut isn't there IMHO.
Here's some V-Raptor v.s. SSD comparisons:
http://www.xlr8yourmac.com/IDE/SSD_vs_VelociRaptor_vs_Raptor/SSD_vs_VelociRaptor_Raptor.html
.