I just reread the original post.
Going just by what was available in 1999 when these systems were on sale: Yes, there was a speed benefit to SCSI if you put a bunch of money into a good controller and one or more good disks.
This is both because Ultra-3/160MB scsi was introduced at the tail end of 1999, and for the DMA issues commodorejohn mentions. (Although, I think IDE was completely DMA ready by the time 1999 rolled around, I'd need to go research it.)
If SATA is available, there's literally no good reason to bother with SCSI at all unless you happen to have all the equipment around, or you need at least one SCSI interface for some "legacy" reason (such as data transfer with a synth, for example.)
SSDs will make a huge difference even on seek time alone, but an interesting thing is, most spinning disks don't even max SATA 2 (3 gigabits) so if you need big sustained transfer speeds (unlikely on a PPC Mac, though) then SSD is the way to go as well, because you're going to get better sustained transfer speeds in addition to the reads and writes.
Of course, this all depends on the specific data you're working with and these days, fewer and fewer things are happening in real time, and video production has almost completely eliminated realtime.
That said, the built in IDE is probably going to be fast enough on those systems -- I did plenty of DV video capture on those systems with no trouble. The key is using a separate disk, ideally on its own controller, but it can be the slave disk if need be, and keeping the disk free of fragmentation.
Audio only may be slightly different though.
There are times when it matters. The SCSI controller support in NetBSD is very mature, so my Power Mac 9600 server has an 80 MB/sec ATTO SCSI card with 2 TB hardware mirrored SATA on a SATA-SCSI adapter. Could I have just used a SATA card? Sure, I could've. But considering how slow the busses are in a 9600, reducing overhead by using SCSI made more sense.
Does NetBSD not treat SATA like SCSI? Everything else does, including Mac OS 7/8/9, as far as I've seen.
Though, if you have a SCSI card or you have a system where you can't easily a SATA card, an adapter like that sounds like a good idea. Do you have a link to the one you used?