It shouldn't cause input lag, but you'll find that controllers in general tend to be less precise on PCs. This is because most console games (or shooters at least) have auto-aim, where the console adjusts acceleration, sensitivity, and in some cases even reticule motion to aim for you.
You'll need either custom drivers or a program like Motioninjoy to make a PS3 controller work on a PC.