First of all, SCSI is NOT unreliable, the opposite is more true, as it is more reliable than IDE. That said, it can be more difficult to set up, as it requires proper termination to function properly due to the daisy-chain nature.
Tekram makes very good SCSI cards. Just use the original W2K drivers if present, and it should work ok.
You dont state if you have more than just the CDRW connected to the card, so i assume it is. Make sure the jumpers are set correctly on the drive. SCSI requires proper termination on both ends of the chain to function properly. The card usually sets the termination automatically, if not, you can set it in the BIOS or with a jumper on the card. On the CDRW there will be a termination jumper. Make sure the CDRW is on the LAST connector of the SCSI cable and set the TERM jumper on the drive. Make also sure the Adapter is on the FIRST connector of the cable, so all conditions for proper termination are set. DO NOT use connectors in between and leave the ends open, so the calbe will be shorter. It can mess up termination.
Hope this helps.
Good luck,
-AB-