It's kinda funny because cloudy cover are a smaller portion of signal loss at GEO, (most loss is due to distance), but it affects that signal quite a bit once satellites are tweaked to get signal to Earth. Most GEO satellites try to have something like 95+% uptime due to average cloudy days in an area, which means they account for those really bad days where the clouds are just too thick. They use weather stats to project how much cloud cover each region will get so they can build bigger beams for that area.
In the past those beams would cover large areas (Like the entire USA). Now they're getting smaller (State Sized) so they can tweak how much signal could go to say Washington vs. Idaho. They're always trying to make this stuff better. But those newer sats at GEO cost 300+ million dollars per sat and are expected to last 20+ years. So it'll be a while before this new generation of GEO sat is out there.
The workaround would be. More signal power at the satellite (costly), or you as a consumer get a bigger/more powerful receiving antenna.
People keep comparing Starlink to their ideal non-rural internet connection. That's not what it needs to compete with.