If you want to use modern IDE DMA modes on a classic Amiga - you can't. There's never been an addon that can do it and never will be. The AmigaONE is the only real shot on an "Amiga branded" machine.
pio modes really suck - for classic Amiga systems I'd strongly recommend SCSI, especially BPPC/CPPC SCSI.