I think you need to plug the gaps in your knowledge.
First the Scottish economy, and its potential is massive. Even the staunchest Pro Union economists concede to that fact. We have a very modern economy consisting of renewables, engineering, financial services, tech, creative, construction. Fuck we even have a space industry! I won't mention the abundance of renewable energy potential and food, drink and natural resources.
Scotlands current economy is very strong for such a small population and we have one of the highest educated populations per head anywhere in the world. So we would need to be mis managed beyond the realms of possibility to make an arse of that.
There will be initial investment costs, such as infrastructure improvements and setting up federal banks etc. But Scotlands potential is significant to the point it could, no it should, become a nordic elite economy.
The only folk I know that don't like Sturgeon are orange Lodge types. I think I can name about 5 Tories that I know. The rest are SNP and the younger generations are all strongly pro-indy.
It's the North of England that pains me. I have strong family connections to Manchester and love the Northern cities. They will be left to follow the will of the Tory South. Brexit for me though has opened up an ugly rift to the political ideals of us Scots and a dark side to the union I am not comfortable with.