By about 2000 or so, pretty much any SCSI drive would keep up just fine. The later 7200 IDE drives with SCSI adapters even worked. Technology improved a lot in that ten year range.
Earlier than that and I'd get Cheetahs or at least Barracudas. Seagates from that era were about the best ones to use in my experience.
BTW, the audio drive can be pretty much anything, they aren't picky.