Well I support SNP as a means to an end. When Scotland is independent it will vote for its own government. Presumably initially some kind of centre-left coalition, in line with majority politiical opinion in Scotland. I don't think SNP will last long in independent Scotland. Not everyone's view, but parties would realign to new situation.
It is the UK government that spent oil revenue without saving any. It is the UK government that took us into illegal and expensive wars, costing many lives as well as billions of pounds. It is the UK government that presided over a bank system at the centre of the global crash. It is the UK government that is dismantling the welfare system and bunggled its way out of the EU.
It would challenging for any new Scotland to equal that level of failure. Scotland's current financial poisition is a result of being part of the UK and subject to these and other failed policies. What would Scotland look like if we had 1) set up an oil fund like Norway 2) avoided illegal wars and paying for weapons of mass destruction 3) control over our own regulation and spending priorities? We can't change the mistakes of the past, but we can learn from them. If you are correct that Scotland's financial position is parlous, then it seems beyond weird to use this as an argument for staying in the current arrangement that got into that position in the first place. If we want to improve the situation the answer is to grow up and take responsibility for governing ourselves.