I have been using SCSI cd-rom/cdrw drives for years on my 1200, 2000 and 3000. Once set up correctly, they all have been working great. Even on-the-fly copying (cd->cdrw) using MakeCD works without a hickup. Very reliable.
I don't use my cd-rom drives often, though.