Well, from a performance stand point, the consensus seems that IDE and SCSI drives are comparable based on the same rated speed.
For my purpose, however, I prefer SCSI because of it's robust driver support for modern (and old, I suppose) OS. I've always dreaded when I had trouble enabling DMA on certain system configurations. When it works, it works beautifully (IDE). But when it doesn't, it's extremely annoying. At one point, I had to disable DMA for the CD drives to get it to function properly. With DMA enabled, the whole system hard locked when the system accessed the CD drive. Then it would work again in few minutes....and then become frozen again, and so on. After disabling DMA, system worked fine. However, whenever there is access to IDE drives, the mouse starts stuttering and the system overall became sluggish. To have an enjoyable operating environment, you NEED DMA 😉 BTW, this problem I had was a VIA based board using VIA 4-in-1 4.25 (maybe 4.26?) drivers. Hopefully the latest 4-in-1 solved the problem already. Note that this problem happens only with certain hardware and hardware combinations (such as using OLD IDE devices that cannot handle DMA reliably).
Another disadvantage, IMO, is that IDE performance, stability, and functionality is largely dependent on chipset manufacturer's driver support. Just look how long we came with VIA's 4-in-1 drivers. 😉 Each time a new motherboard chipset (specifically, south bridge chip) becomes available, we'd have to be concerned with driver maturity for IDE, for _EACH_ OS. EVERYTIME you switch to a different chipset platform. And for a frequent upgrader like me, it bugs the heck out of me.
After going SCSI, all I do is transplant the SCSI card and devices to the new rig and she's good to go. Like Ron Popeil Rotisserie, "Set it, and forget it!!" 😉 With any recent OS, there already are good, old, and robust SCSI drivers already included on the OS disc for major brand SCSI cards.
For the hard drives, I use both SCSI and IDE (SCSI for OS/apps, and IDE for large, multimedia files). You simply cannot beat the price/peroformance ratio of a good IDE hard drive.
Tako/tako_chu