You probably won't see much improvement in AH performance, but if you use your PC for creating multimedia, video editing, or work with large files then SCSI is the way to go.
I'm running an Adaptec 2940U/UW with a Seagate Barracuda for C:.
My swap file is assigned to D:\ (another Barracuda) this increases swap file performance and allows it to handle high load multi tasking conditions that an IDE equipped PC would choke on.
SCSI is a more expensive in initial cost vs IDE, but in my experience its very durable, so in long term use it may be cheaper.
I bought the Adaptec 2940UW, (2) Quantum Fireball disks, and a Toshiba CD-ROM in 1996 and all are still in use today, I added a CD-RW this year so I currently have 6 drives installed.
SCSI busmastering allows up to 15 installed devices but only uses 1 IRQ for the controller, this frees IRQ 14 and 15 since you don't need to enable onboard IDE, this helps eliminate IRQ conflicts when configuring system hardware.
The only problems I've had were with two Seagate Barracuda drives, the 'Cudas were fast but short lived due to overheating.
I now have 12 fans in my SuperMicro server case to keep it all cool.
