Gosh I use Loctite all the time on guns!
Bead/fiber optic/tritium front sights on shotguns. Not a whole lot of threads holding it on there.
Green (penetrating) is just the thing for scope mounts on zeroed rifles. You don't have to take everything off and re-zero. It's almost as strong as Red so you have to be pretty darn sure you're not going to go with a different set of rings/mount. I haven't used it with the actual screws holding a scope to a mount since I do have the habit of moving my optics around. When installing for the first time I usually use Blue.
Author of the linked article is right --- Blue or Red is great for 1911 grip bushings. The comments are also right, Loctite is great for screws in holsters.
Seems like most of the parts of my house either have Loctite or lithium grease on them