Is the Poisson distribution useful for modeling goals?

It turns out, the Poisson distribution is great for modeling football goals at the league level, but not so much at the club level, despite what's been said on football modeling sites.