Adding the extra security may mean that your scope won’t come loose after a few thousand rounds.  I’ve seen guys with battle rifles with $1000 optics on them and after a few thousand rounds, the mounts came loose.  None of these individuals were using loctite.   Over torquing screws is something to be concerned about because screwing a mount in as tight as you possible can does not mean more security, it actually means more stress.   Loctite doesn’t add stress to your gun mount it just helps keep the grip on your screws so they don’t rotate after long firing periods.

There is much debate about which scope mounts are the most durable.   Some scope mounts are stronger than other just based on the quality of the metal, but the reality is that all scew on mounts can come loose over time.   One of the secrets that experienced shooters need to pass on is the use of loctite.   If you are going to be using a scope for serious shooting or putting an accessory in a firearm, you should seriously consider using loctite.