or good oldshool USB 2.0 Cypress FX2LP CY7C68013A or its Chinese clone Corebai CBM9002A
cy4611b___usb_2_0_usb_to_ata_reference_design https://www.farnell.com/datasheets/62992.pdf Back around 2005 a lot of USB HDD enclosures used this exact chip.
All the above needs is LBA to CHS translation.