I’m actually curious about this as well. Maybe I’ll create a spreadsheet that folks can update to include a general location, moon phase and cloud cover (high, medium, low) to get some data....
Or just look at historical data for the same thing

But if the moon impacts tides there’s no reason why it wouldn’t also impact cloud cover with moisture levels changing for a given location