If you want to use a CF card specifically, you need an Acard SCSIDE bridge and then an IDE to CF adapter. This works fine and I used to run systems like this myself. However the Acard bridges are a bit difficult and expensive to source in 2025.
On the other hand, if using an SD card is acceptable, there are BlueSCSI and ZuluSCSI emulators available for less than the Acard would set you back. There is also the SCSI2SD, but it is a bit more cumbersome to use.