Sunny cows put to bed ‘pot of gold’ myth as cloudy days loom