I use Loctite 603, the old green high strength bearing fit, mostly because I've got it in stock. It is said to be designed as a retainer for cylindrical components rather than thread locker so it ought to be better at the pipe retaining job.
Trying to extract meaningful data about the actual real world strength of the umpty-six breeds of Loctite makes a two bottle of whiskey hangover seem like pleasant relaxation. I've never really gottten a handle on it but usually manage to choose something that works.
603 claims 22.3 Newtons/sq mm, 3,250 psi shear strength under iSO 10123 test conditions. Which is pretty strong. The data sheet gives explicit cure / strength curves for aluminium substrates too. I doubt if it gets up to much over 80 % of its strength in steel but it does cure properly.
Loctite 2700 is a thread locker claiming around 35 - 40 Nm / 25 - 30 ft lb breakaway torque and 20 N/sq mm, 2900 psi shear strength so its pretty similar strength to 603 in steel. Being a threadlocker it really doesn't like being used in thicker layers or being used with an activator. Strength with activator is about 1/4 of that without. The really worrying thing about 2700 is that it's very sensitive to substrate. According to the dat sheet it gets to full strength on steel and zinc, half strength on brass and one third on stainless steel and zinc dichromate. No curves for aluminium which is worrying. Given the low strength on stainless steel I suspect that oxide layers inhibit cure and seriously degrade performance.
2700 is a modern formulation claimed to be health and safety friendly. The sort of thing that generally means the new improved doesn't actually work as well out in the real world as the old stuff. Getting the best out of it probably needs much more careful preparation too.
Clive