I was thinking, does walking closer to Leo make hitting all the bullets in the spread more consistent?

Well you shouldn't be holding the buttons through the cutscene when you can use the animation skip like Big_Jim said. I usually do the skip and then hold the buttons and I've had a 90% success rate. Honestly, I'm pretty sure its not RNG but you might as well call it that x3