Due to a weight stack, a weight station can get pretty noisy if handled incorrectly, but only if you let the weights speed up on each other. The rollers and pulleys don't make much more than a quiet sound caused by sliding.
Are the power stations noisy?
Ferit Yikilmaz