Many of the better holo sights have those tiny screw locks, my JP4, Fastfires and others. I liked the holo's because of their petite size. I sought counsel from a warranty station of a firm that offers both types. He recommended the tube type as those tiny holo's coming in for repair after having their lens pop out from droppage or collision w/an immovable object AND he added that under field conditions precipitation (raindrop/snowflake/debris) can put it out of commission as the led emitter is exposed to the elements. I think its JP that has a clear plastic rain hood accessory available to slip over their sight to help prevent that. Even w/a lifetime warranty, when one comes in w/the lens out of its loop indicating abuse, it may be outside of the terms of warranty. Anyway, thats what I was told. FWIW, he mentioned that their tube types coming in w/the front lens busted and heavy ring marks on the portion of the tube where the lens is mounted indicating over torque of the rings would receive a critical eye too.
That said, I've a few holos, a Fastfire, a Fastfire II, JP4 and several UD and a aimpoint red dots. All good but for the ruff stuff, I look to the red dots.
Get what makes you happy as you will be the one using it.