1) SCSI drives do cost more, but are generally more reliable and longer lasting then SATA/IDE drives. If you opt for Seagate Cheetah's, then you may get much better performance.
2) SCSI host adapters add cost to the computer, and if it is a RAID controller, it will cost even more.
3) Windows XP has a bug which inhibits performance of SCSI drives. Windows 2K is fine with them though.
Those are the negatives. That said, I use nothing but SCSI drives in my home systems, except for the Wife's computer as she had to use Windows XP for an application they use at her place of business. It will not run on Windows 2K.