As a Scot living in London, independence is that absolute last thing I want.
It would absolutely break my heart and at the moment my personal experience is that support is 50/50. It could go either way. The one ray of light I am holding on to is that the SNP are essentially adopting an anti-democratic stance posing as democracy. Much like EU remoaners (not to be confused with people who simply voted remain), they refuse to acknowledge the results of once-in-a-generation referenda that do not produce the result they want. They claim that Scotland has the right to decide its own future. While this is fair, they forget that this issue was settled 5 years ago. Scotland voted convincingly to remain part of the UK. Then, the UK as a whole voted to leave the EU. The SNP position has always been "well if something changes in the relationship then we want another referendum". Slimy tactics. With this line, the SNP were always going to shout for another referendum whenever anything changed that THEY did not personally approve. First it was the Tory majority of 2015 remember.
The people of Scotland really need to wake up. The SNP have a single agenda, yet have positioned themselves as the ONLY voice of Scotland. This allows them to arrogantly claim that the people of Scotland want X, or think Y, and nobody challenges them.
My solution would be to create purely Scottish parties, much as Northern Ireland has. These can be aligned to Westminster parties if they choose, but should be seen to be fairly independent.
The principle of democracy must absolutely start with honouring votes that have already been held. The SNP are rabid anti-democrats much as the LibDems became these last few years. My hope is that people understand that once you start re-running referenda, every other democratic process becomes meaningless.