Well that was weird. I ditched CD Sunrise as well as the CD Driver that comes with OS 7.5, and installed the newer one (5.3.1) from OS 7.6 and it recognized the drive no problem.
So apparently OS 7.5 doesn't work with Apple SCSI CD drives???
So apparently OS 7.5 doesn't work with Apple SCSI CD drives???