Actually it doesn't matter at all whether DMA mode is used on the IDE side or not. PIO limits you to 16 MB/s which is most probably faster than your SCSI. Your local SCSI has its own DMA scheme, totally independent of IDE.
PS: Trying to use DMA with a CF card not supporting it probably causes the lockup.