In my experience yes. I've had deer run 50 yards, then come back and not move next time the cam goes off.

IMO if you aim the camera down so it's over the deer's head they don't spook as much. If it goes off right eye level they will spook.