The EU has made it clear that any new members will also have to join the Eurozone, which is falling to pieces. As you say, good luck with that.
And their application for membership will be vetoed by Spain anyway because they are fighting a similar battle to keep Catalonia as part of Spain. If Scotland gained membership it would offer massive encouragement to the Catalans.