Turns out this machine, for some reason, simply cannot boot of SSDs with neither OpenBSD or FreeBSD on the box. Only spinning drives work.
It's an old Dell Inc. OptiPlex 980. I suspect there is some issue with the BIOS of the machine and the BSD bootloaders as Linux with GRUB works on SSDs.
