This may not be the right place for this question, but I'm planning on
using OpenBSD on this system later, so here goes.

Has anyone tried using a SYBA Compact Flash to IDE adapter with the
Supermicro P4SCT motherboard? Any luck?

I've already tried with an Intel SE7221BA1-E board and no luck. I
couldn't get the thing to boot properly or allow the CF card to be
selected as a possible boot device.