Wave Modifier Question
As far as I'm concerned, the Wave modifier just moves vertices up and down but doesn't rotate anything because it just works on the single vertices translating them on the z axis depending on their X and Y position.

If you want to make a curved pipe in which the section rotates and not translates, I recommend you to use a curve modifier. You'll need a sinusoidal curve (look here for that) and a curve modifier to apply on the cylinder.