I used to follow the rule:
"If you NEVER have to remove it use N-type, if you EVER have to remove it use BNC"
But, now I have become lazy and I have been using BNC for everything, purely because it is easier to have standard cables for everything.
On the radios I have with N-type connectors, I have been putting N-type to BNC converters and using BNC on both sides.
While BNC is easier, I have personally seen BCS "fail in place" 2 or 3 times. All of these were resolved by simply disconnecting and then reconnecting the BNC connector. It looks like the the center connector loses connection, which I think could be it oxidizing over a long time or maybe it moves slightly inside the connector. In any case the N-type connectors are much more robust and I have never seen one fail.