That's a fair point. It might still be of some hypothetically real use if there are multiple sources accessing the data at the same time. But you're most likely right - but there is still the upgrade itch argumentDepending on how your zpools are set up you might not see any speed boost with NVMes:
10GbE => 10 Gbit/s => 1.25 GB/s
SATA => 6 Gbit/s => 0.75 GB/s (say 0.5 GB/s per SATA SSD to be more realistic)
So with four drives in raidz1, which gives streaming read and write speed of [number of data drives in the pool] times [speed of the slowest drive], you're likely already limited by the network. (Or at least not by the drive interface.)
Looks like I will need to upgrade the server first anyway, hahaNo such thing as an AIC that implements bifurcation. You either have UEFI support for bifurcation or you need to use a PCIe switch card -- and the latter can certainly be four M.2 slots on an x8 AIC (random example: NV9524-4I).
The upgrade wouldn't be terribly expensive (not counting the SSDs) though.
I'm thinking either Supermicro H13SAE-MF or Asrock B650D4U, that's the most expensive part.
For CPU, Ryzen 7600, that's not very expensive.
RAM, I don't know, isn't DDR5 pretty cheap these days? I won't need more than 32GB anyway.
I guess I can offset close to half of the cost with the current hardware. Or at least I hope these server MBs and CPUs keep some value for a long time and don't drop close to zero like desktop components do.