SCSI hard drives are more for Enterprise applications where they will be in almost constant use. IMO, they are WAY to expensive to even CONSIDER in a SOHO environment, SATA is the way to go.
SCSI disks also have the highest RPM's, up to 15,000. SATA's highest is the 10,000 WD Raptor, and I believe IDE is only 7,200.