I think early CD-ROM drives with proprietary interfaces were basically never bootable unless there were controller cards with option ROMs and I've never seen one.

These drives were from the early 90s, so that wouldn't have been the reason why Windows 2000 could use a boot floppy - maybe some computers had SCSI drives connected to controllers that only supported booting from hard drives