Hi Sandman,
What speed does your CF card give with Sysinfo in the 3 configurations?
You will find that the SCSI bus will run at the same speed as the slowest scsi controller on the chain.
So, if your WarpEngine and IDE<>SCSI adapter have a max speed of 80Mbps, and your HD has a max speed of 40Mbps, everything will run at the slower speed. I'm not suggesting that your HD is actually the slower device, its just an example :-)
It is also possible that the buffer on your IDE<>SCSI adapter is quiet small and so doesnt handle high speed communication very well. What is the speed of your CDRom drive (ie.42x) and what kind of throughput do you get from it?