Annual sunshine is around 1300 hours in Glasgow, 1400 hours in Manchester, 1500 hours in Birmingham, 1700 hours in London and Paris, 2500 hours in Rome and 3500 hours in Cairo.
So it's not so sunny, especially as you go north, but films/TV do exaggerate the problem. "I'm from London" regularly gets a comment about terrible weather, "I'm from Paris" does not.
There's very little solar power in Scotland, as you'd expect: https://electricityproduction.uk/plant/solar/map/
(Figures from https://en.wikipedia.org/wiki/London#Climate and so on.)