Why not go SCSI2SD? (
http://shop.codesrc.com/) At $65 to $73 USD it is a cost effective option.
Back to the question, both an IDE and an SCSI3 drive will saturate the SCSI-2 bus, but the is a conversion "hit" going from SCSI to IDE that cuts the transfer rate.
