Did you know a male N will fit perfectly into a BNC female? All the internal dimensions are identical.

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.