I consider myself British & think that the Brexit vote was a huge mistake though it was probably inevitable given our political system. I think it likely that the UK will want to rejoin before too long, as to if they would let us i doubt i will see it in my lifetime.
I cannot for the life of me see how Scotland can be more prosperous by leaving unless it rejoins the EU in its own right. That possibility is vanishingly small as it would give a green light to Catalan independence, something that Spain would not countenance!
But ask the average strapped for cash Englishman why the Scots get free prescriptions, eye tests, Dental care University fees etc & they dont?
Most of them would be quite happy to see the back of the Scots as they wouldnt have to subsidise them any more!
Be careful what you wish for.