15 years ago when I started clay shooting I was obsessed with the score, on reflection I must have made tedious company.
As tends to happen I got to meet fellow shooters and got to shoot with them regularly ( now twice a week). One particularly exceptional shot in the group offered some incredibly useful advice, "stop worrying about the score" and instead concentrate on having fun. Like you, Sian, in my day job I'm disciplined/unemotional/confident so stepping into a 'just have fun' mode wasn't exactly natural. Now the only person I compete against is myself - once I've hit a target, I'll try breaking it earlier or later in it's trajectory - the odd thing now is that since taking this approach my shooting has improved massively and I enjoy it so much more as a result.
So whilst getting inspiration from a coach might be one route, shooting with a different group of people for inspiration is another.