There's a wealth of really good information only a couple of clicks away, at the manufacturer's website…
Loctite change the numbers of their products from time to time, so what follows reflects my stock, not what the latest numbers may be. Hopefully, they haven't changed.
222, 'Super Screw Lock', is suitable where the fasterer that has to be undone has a long thread engagement. The amount of torque needed to break the bond will be related to the area of thread that is bonded, so avoid high-strength products for screws (in most applications).
243 is a medium strength preparation, stronger than 222, and is suitable for nuts, or where there is short thread engagement if screws are used.
These two will probably take care of almost all needs.
609 is a high-strength retaining compound, and if used on fixings, will be awkward to undo, without heat.
If you think the plethora of Loctite's retaining compounds is a nightmare, don't even think about their range of sealants, etc.!
Hope this helps.