I just see the success stories being lauded in places that favor solar (obviously) with less discussion about some very real problems of “what if” it snows or you have LOTS of cloud cover at the same months that you have life threatening cold (hello Chicago, Detroit, Columbus, Pennsylvania and New England).
Think of it this way.
The technology is getting developed in ways that help engineering and manufacturing move along the learning curve. The price of solar panels has dropped by like 93% in the last decade or so.
The first adopters are going to be the ones who will see the highest returns on investment (see: Sun Belt) ... but as the technology matures it will start moving into "less optimal" regions, like the ones you have identified, and continue to grow market share.
One of the things that people tend to forget is that stuff like "clouds" tend to be local phenomena. With a wide enough (geographically) grid system, if it's cloudy somewhere it's probably sunny somewhere else, creating opportunities for import/export arbitrage of energy. Just because a specific location is "solar poor" does NOT mean it is incapable of accessing solar power generated elsewhere.
Case in point ... England tends to be a "foggy/rainy island" that isn't exactly known for its sunshine. However, Morocco has PLENTY of sunlight! So the UK is building a solar farm in Morocco and a high voltage DC connector cable to link that solar power into the UK power grid even when "the weather is bad" in the UK, because it's probably going to be sunny in Morocco.
A similar international transmission line for solar energy export is being set up in Australia to send power to Singapore(?).
Also, you don't need to "pave the ENTIRE world in solar panels" in order to generate enough energy to match the CURRENT demand for energy on a global scale. I think the actual figure is something like 1% of global land area would be enough to generate sufficient power for the ENTIRE world, at current solar panel efficiency rates. To put it mildly, the world "wastes" more than that amount of land area on golf courses, right now (including in places where golf courses are ecologically unsustainable). So it's a matter of "pick your priorities" for how you want to do things.
Better yet, if "every house" in any given country (or state) had solar panels on their roof and batteries, MOST (if not all?) of the energy demand for that country (or state) would be produced without needing to dedicate "extra land" to the generation of energy for home, businesses and industry.
In other words, it's kind of amazing how much "land area" that solar could be deployed on (residential rooftops) is currently being "wasted" rather than exploited for energy generation. So in terms of "area needed" ... there's plenty of "room" for more solar without needing to conquer the countryside.
And then there's the field of Agrovoltaics, combining farming and solar, where farmers are starting to realize that putting solar panels in their fields reduces water consumption, produces better harvest yields AND they can get paid for the electricity that their land produces. Win-win-win for farmers. Just needs some more developments in tools, tech manuals and techniques before Agrovoltaics starts revolutionizing the farming industry for field crops and open pasture animal husbandry (farm animals appreciate the SHADE created by the solar panels, who knew?).