@Gina My limited experience in Asturias is that it is nothing like as overcast as NL - even Galicia is better than NL. Another thing you might want to consider is the taxes in the different autonomous regions. It's my understanding that Galicia's might be quite high - don't know about either Asturias or Castille & Leon.

@Gina Currently visiting Oviedo in Asturias (from Porto, PT where I live). It seems to check a lot of the boxes you listed. (I think the airport might be a problem though https://en.wikipedia.org/wiki/Asturias_Airport ) Asturias is beautiful with mountains, beaches, unique and wonderful cider and great food. We come here from Porto once or twice a year.