I think you can help players improve their goal scoring technique. (That's improve, not completely transform them.)Composure in front of goal is clearly a natural ability. I do not think you can drill it into someone on the training ground,,,,,,,,,,,mores the pity.
But it isn't done by endless repetition of shooting practice.
A good coaching saying is that practice does not make perfect - it makes permanent. So be careful what and how you practice!
This will sound very weird, but I would have Sykes practising finishing with an imaginary ball. It could help him concentrate more. Another drill (going in the opposite direction) is to get him to focus on striking the ball on a particular coloured panel. So the focus is on the process not the outcome.
(Above based on some sports psychology learning and experience)