I'm not sure I can tell you why the industry uses BNC, what would you prefer? If you are thinking that an "F" connectors would do fine and is easier, it is not as solid a connector. If you examine the design of the BNC connector, you will discover that the shield/ground has a double mating surface, much better chance for a very good connection with solid shielding. Also, the BNC is a precision connector, the pin and socket are made to specific tolerences. All in all, it is an excellent connector design.
That being said, there are several options for BNC connectors and tools. I personally prefer the AMP brand of connector and crimp tool, though it is a precision connector and if you get cheap (non-standard sized) RG59 or RG6 you may have problems crimping it. It has been my experience that results are better if you buy a connector and matching crimper. Unfortunately, I have a drawer full of crimpers and dies for BNC, SMA, N, F, SMB, TNC, etc. Lots of different connectors, lots of different dies.
There is a crimp option that is a tapered barrel fixture. You crimp it on with a $100 radial crimper and then screw in whatever end you like (BNC or RCA). It is a nice finish solution, though the connector body is a bit longer than others.
As much as I dislike them, we routinely use the screw on kind of BNC connectors for CCTV stuff. They are fast, cheap, and ... adequate. Having a background in radio, I've never been impressed with the screw on type at all. However, they make a usable fitting for CCTV.
Good Luck! It is only my opinion, based on my experience and education...I am always willing to learn, educate me!
Daron J. Wilson, RCDD
daron.wilson@lhmorris.com