The choice between SMA and BNC connectors primarily depends on the frequency requirements, with size also being a factor.
Their durability is not a problem; it depends on how much you spend.
The SMA can respond to frequencies up to 26.5 GHz.
Although BNC can theoretically operate up to 6 GHz (but in practice, it's rarely used above 1 GHz).