The only way to get a read on what is possible is model a combination of wind and solar in various locations, with many years of weather data.
I have heard that wind is good in Germany in winter specifically off shore wind, in summer I bet solar does a lot better in Germany that it does in winter.
Solar is cheap enough to work for Germany in summer.
Finally the the EU could get together and arrange some HDVC links to land in northern Italy. West side - Spain + Morocco, East Side - Greece + Turkey.
Just the threat of building the HDVC links might make the Russians realise their gas threat has an expiry date.
Explore SunCable's innovative solar projects as we revolutionize renewable energy in Australia and the Asia Pacific. Building a sustainable future.
suncable.energy
For the project above, running a 3.2 GW link for 4,200 KM is estimated to cost roughly $12 Billion AUD. That includes a challenging deep water section which they probably don't have in the Med Sea.
The Morocco to Turin link seems to be roughly 2,000 KM by plane, the sea route might be a bit longer.