Earlier quoted context omitted.
DACs are very cheap (second hand and AliExpress) and they never use much W. If both machines are near each other though (which a DAC cable implies) and both run Linux and both support Thunderbolt, you might be better off with a direct ethernet over TB connection. Whether macOS supports such, I don't know. The other side will then also need a low power NIC (of which fiber and DAC over SFP+ are less power hungry). What…
I just wish someone would come out with a PCIE 4x1 capable card with SFP - my main desktop’s non-GPU expansion slots are all 4x1 electrically and even the one you linked is a 3x2. As far as I can tell the only 4x1 cards available are RTL8127 or AQC113 RJ45 ones :( I suppose an NVME riser is also an option, albeit janky.
edit: on looking closer, that still seems to be an x4 card.