Looking for something that i can plug into server USB for dry contact input so NodeRed can control. I know that a RPi can be used, but I'm looking for something more robust 24/7
Does it have to be USB? An ethernet based relay would be better IMO.
Something with modbus/tcp interface is directly communicable from node-red.
If you want 24/7 and robust, you might want to consider a small PLC with built in IO. Something like the RS-PRO Mini PLC : Controlling lighting using RS Pro Logic / Genie NX | njh