...Anyone use it on their front sight screw or any other firearm parts? Red, blue or some other color? Red sounds pretty tough to un-do. ...
For sights with steel mounting parts (not plastic, as DocDorle noted), Dave Dawson of Dawson Precision (makers of sights, among other things) recommends Loctite 262 (red "threadlocker") for the rear sight, and Loctite 620 (green "retaining compound") for the front sight.
You can buy this stuff from Dawson:
https://www.dawsonprecision.com/ProductDetail.jsp?LISTID=80000EDE-1300732007
Just using the terms "red" or "blue" to distinguish the Loctite products is not going to be sufficient these days, things have gotten complicated. I counted nine different types of "red threadlocker" on the first page of a search of the site, and nine different types of "blue threadlocker" before I stopped looking.
The website is:
Adhesives, Sealants & Surface Treatments - Henkel North America
I quickly got lost in the website research, so I just use Dave's recommendations, with very good results. Recently I had to change a set of sights that I had mounted using the 262/620 combination, and found that while both screws could be removed, it was only with considerable pressure. Those sights were definitely NOT going to move by themselves.
The Loctite that remained in the parts looks like a whitish, thick, dry, paste. I was able to clean it off using a cyanoacrylate remover product called "Un Cure" that can be found at hobby stores. I've also used acetone to remove Loctite.
That, and a steel brush.
Chris