I've got a nearly all SCSI system.
Adaptec 3200S RAID controller for hard drives
Adaptec 29160 controller for everything else (could get away with a much lower end card, but I had this one before I got the RAID card)
2 IBM Ultrastar 18LZX 10k drives
2 Seagate Cheetah 9LP 10k drives
1 Quantum Atlas 10k drive
2 Plextor Plexwriter 8/20 CD-Rs
1 Plextor Ultraplex 40xmax CD-ROM
1 Pioneer 304S 10x SCSI DVD-ROM
1 DDS2 DAT Tape drive
1 Iomega ZipCD 12/10/32 (IDE)
I recently added the iomega drive, due to the incredible deal at compusa, I have regretted it ever since, because the drive is significantly faster than the 8x drives, enough to entice me to use it, but every time I do, my CPU utilization spikes to approx. 40%. But aside from the CPU issue, and the speed, I'd need 6 IDE channels to fit all these devices, vs. a single SCSI channel (although I'm using 2 so I can take advantage of hardware RAID). I changed over from SCSI to IDE years ago, and was incredibly surprised at how much more responsive my system was. Back then, the hard drive I had was so much faster, I was completely stunned. Now my drives are all a little old, the Atlas 10k is the newest I have, and it's a generation old, soon to be 2 generations old. Nonetheless, my harddrives easily outperform any of my friend's computers, most of which are running on 75GXP drives, which is the fastest IDE drive that I'm aware of. As for serial ATA, it doesn't seem like anything that exciting to me, since IDE drives are not capable of using 150MB/sec, and if they stick to the 2 drives per channel technology, it'll still be way too little. If it uses signaling similar to IDE, then drives will have to take turns using bandwidth on the channel, unlike SCSI. By the time it's out, Ultra 320 SCSI will most likely be available, but even so my U160 SCSI that was out a year or two ago is still faster than serial ATA. My drives are already hot swappable thanks to my SCA backplane, so the only new feature would be the small cables. I have a very large case which helps reduce clutter and increase air flow, but I would still appreciate the serial ATA cables, which appears to be the only worthwhile advantage to serial ATA.
SCSI is definately not for everyone, due to cost. I see too many people here insulting SCSI who have obviously never used it. Anyone who thinks it's not worth the money has never used an up to date SCSI system. As for whether it's worth it to individual people is based on what tasks they perform on their system, and what their budget is.