Holidaying in Spain probably is cheaper, but living there would be a completely different matter. Especially if you were earning your salary there.
2 euros for a coffee is not remarkably cheap - I pay about the same if I have a coffee when I pop over the German border. It is cheap for me, as in Denmark drinking a coffee in a coffee bar would cost me six times that, so I gave up drinking coffee anywhere but at home years ago!
Comparing prices between countries does not really tell one anything, as prices have gone up everywhere and wages have not, nor have pensions, so everywhere people are complaining that their standard of living has deteriorated.
Certainly, reading Gransnet I get the feeling that you are very hard hit in the UK, but then again, we all tend to complain about rising prices - no-one starts a thread about things, if indeed there are any, that now are cheaper than they were before Russia invaded Ukraine.