Oh dang, I totally missed the name of this community when I commented. My knowledge of and opinions on rf connectors come from working on large aircraft mounted systems, where turbulence can cause a nightmare of threaded connector sleeves vibrating loose and bent pins. In this situation you either need vibration damping or a more mechanically robust connector like BNC

SMA or bust. The other three connector types introduce a lot of noise compared to SMA in my experience. BNC is my goto if I want a noise profile similar to SMA but the device I’m working with isn’t vibration damped.