If you were to compare IDE and SCSI, side by side in a high end server multi user heavy load situation, SCSI will always win - it'll always be the most expensive too.
Think of IDE as consumer grade hardware and SCSI as commercial.
For single user situations, IDE is fine and can out do some SCSI drives but for server situations, I'd always go with an advanced SCSI interface. I'm a small time user and I don't have alot of $$$ to spend on hardware but I've found you can still have a good system with high reliability pretty cheap. Drives like OC describes are real cheap and less than latest technology RAID cards are even cheaper.
If you want ultimate performance, there many high end SCSI cards capable of 160Mbs through put and high end SCSI drives that spin at better than 12,000 RPM. You can stripe these drives and get much better performance out of a striped array (using hardware raid) than a single drive.