After application, the screw connection can always be loosened again. Medium-strength threadlockers can be loosened using normal hand tools. High-strength threadlockers require localised heating of the connection to around 250 to 300 °C in order to soften the material and loosen the screw.
Henkel's numbering system is complicated. Even different numbers in the USA compared to EU. The following should help...
Loctite 243 Blue is 'medium strength' formula for metal threads like nuts/bolts. The benefit is that it lcan be removed (with force).
Loctite 290 Green is 'high strength'
Loctite 272 Red is 'heavy-duty strength' and is permanent but expensive
Loctite 221/222 Purple is 'low strength'