Yeah, it really depends on what aspects of performance you are looking for. If you want transfer speed, ATA100 and some SCSI drives may be fairly close.
But if you look at seek/access times...almost any recent (and some old) SCSI drives will whup ass vs. ATA100 drives.
And you will notice a bigger difference in seek/access times than you will in transfer rates.