You definitively want your muscles to be tight for weight lifting. But you also want the flexibility to do the full range of motion.

What you absolutely don't want is to stretch before the exercise to loosen up the muscle - you're not suddenly going to gain much extra range of motion, but you will reduce your ability to control the movement.

Stretching after (our outside of) your regular workouts, on the other hand, can be useful.