I still have a few parts missing, but I'm playing with what I've got. I've found that at least in some IDE-to-CF adapters there are a few extra connections beyond what this shows:
http://rumkin.com/reference/aquapad/media/CFtoIDE.pdfFor example, in the one I've analyzed, in the CF connector, pins 8, 9, 10, 11, 12, 14, 15, 16, 17 and 25 are not "unconnected", but "tied to pins 1 and 50" (which then go to ground). Not the case for pin 24, though.
This may mean that there's something missing in that pdf, or, maybe more likely, that some parts are not actually made to exactly meet the full specification, which could explain the issues some here are having.
This
http://pinouts.ru/Memory/CompactFlash_pinout.shtml says that those pins are used for the address bus; the CF-to-IDE connector described in the pdf would leave them unused, but if they're linked together and to ground the camera may freak out and shut down.