Might work, might not - I do know some internal A600 / A1200 CF adapters don't like being set as Master on an IDE chain.
I've got no data on an adapter designed to go in a case slot position, that could be good either way (set as slave or master). Also depends on what the DVD drive will or will not take (I've come across some that insisted on being set to slave for some reason).
The advantage of hooking of up scsi optical drive is you can copy data between buses, which usually speeds up transfer to the speed of the slowest device. Although it's more expensive doing things that way. However, without a very recent Kickstart or controller ROM containing a CD file system, you won't be able to boot from an optical disk. Not usually a big deal on the Amiga.
