Finally got a bootable CompactFlash card working in the machine. Everything in above posts might work ( and good to know for gathering CHS parameters of the CF card) depending on your PC/workstation.
We ended up buying/installing
Lo-tech ISA XT CF Adapter rev. 3 from
https://texelec.com/product/isa-compactflash-adapter
This PC/computer has both ISA (8-bit) and ISA-VLB (16-bit) slots on the mother board. Only the ISA (8-bit) were free so the ISA XT CF Adapter would be the one I went with. There are other options even to flash a Ethernet/NIC (ISA) from an old computer with XT-IDE software. The Lo-tech adapter was already flashed with the XT-IDE so it made the process easier.
1) Install LoTech ISA XT CF Adapter (I'll call it "XTIDE-adapter" from now on) into a free ISA (8-bit) slot
2) Insert a MS-DOS 6.22 boot floppy ( you can buy them on eBay easily these days or ask me for detailed steps for flashing from a modern computer ).
2) Plug IDE cable from XTIDE-adapter to CF adapter ( e.g StarTech.com 3.5in Drive Bay IDE to Single CF SSD Adapter Card Reader (35BAYCF2IDE) )
* since the CompactFlash card compatibility in these XTIDE-adapter is *much* higher/wider than the existing BIOS they can handle non-fixed CompactFlash cards too and even beyond the 504/528MB CF card limits ( not that one might need that )
3) Boot the PC and remove any CHS/user drives. This is critical to avoid confusing the XTIDE-adapter BIOS since it'll do it's own CF card/drive management.
4) Boot into the native BIOS and you'll likely have to press F1 to skip/continue to the XT-IDE BIOS ( this is being loaded into memory from the XTIDE-adapter, press + hold A on keyboard to skip booting from C: and boot from A: floppy instead.
5) Type in:
fdisk
6) Select option 4 to view the partition and make note of what's on it.
7) Select option 3 to delete the partition you have
8) Select option 1 to create a new partion
9) Select option 2 to make the first partition active
10) Reboot
11) Continue to the XT-IDE BIOS and hold A (again) to boot from floppy
12) Type in
fdisk /mbr
13) Reboot
14) This should boot into C: by default and you should be on a clean bootable PC/machine once more.