For the USB to IDE thing, my guess would be that the USB interfaces you tried want to do some newer incarnation of ATA than the drive supports and so they can't communicate, at the extreme that could be LBA48 (48-bit logical block addressing, which is from this century and so obviously isn't going to work on say a 20 year old hard disk) but it could even be DMA, which was optional in early ATA specifications and might have been skipped by cheap manufacturers back in the day.
I don't think logical addressing itself was ever optional, but I guess it's possible that a _really_ old IDE drive might not implement it and yet work anyway in DOS which didn't originally use LBA mode. Doing CHS mode really would be asking a lot, compared to PIO (the alternative to DMA) which really a competent implementation of that USB adaptor ought to be able to do, slowly like a real PC.
I google search for it now and then, and come up with nothing that can be simply installed and used.
I can't find any device that connects the drive with the computer that doesn't require writing a device driver.
It's not a crazy disk format, it's DOS format.
As for hard disk drive interfaces, I have a couple off the shelf USB interfaces to IDE drives. The connectors fit, but they don't recognize the older drives.