There's a many, many post thread here https://forum.vcfed.org/index.php?threads/isa-usb-board.7697... where a lot of the discussion took place, both my efforts and some other devs working on a DOS-based driver.

https://gitlab.com/hakfoo1/ch37x-bios is the actual code.

Post 394 shows a picture of the card I used, which at the time was sold in like 500 AliExpress storefronts for about USD25. The magic word is "CH375" or "CH376" (two chips, overlapping functionality, different enough to be annoying to support in software)

As mentioned in the thread, it tends to fit a weird niche.

For 8086/8088 machines, the other main option is XT-IDE cards, which are like $40+ and they're sort of finicky with some drives.

For a 286+, usually installing a standard IDE drive (or a more modern CF->IDE or SD->IDE adapter) is the easy mode with wide software support.