Surely the smart money is to go to Spain

We do get cloudy days too sometimes :) Although today it is looking fairly sunny all over the place: https://i.imgur.com/4LK7xo8.png

there is another total solar eclipse next year in 2027 in south of spain if the first time not lucky