ConnectX3 and Intel SFP cards are pretty reliable and easy enough to get working on Linux. On my Windows 10 Pro machine, all the cards I plugged in just worked immediately, no driver install required.
I'd start there and if you find you need other features, think about spending more.
My ConnectX-3 on Windows 10/11 machine takes 15 secs to reconnect on resume from sleep. It's not serious issue but a bit annoying. Anyone had similar issue?
I'd start there and if you find you need other features, think about spending more.