Generally speaking, what fails if you over-torque, no wait, I mean over-tighten, no wait, that's the same as torque, I mean over-turn, no wait, I don't mean tip over, I mean over-rotate (whew!) the joint? If a plumber gets to the point he artfully feels is just right, then has to rotate around to point the elbow northeast, is he going to hurt something?
There's some orientation 'allowance' designed into pipe threads, but how different is that allowance in different materials and material combinations: steel, stainless, brass, copper, aluminum, PVC?