Scotland certainly has a lot of natural resources that could be harnessed. Sadly, the interconnect you talk of is not being funded by the EU (bar a token 10 million euro). Not sure what you mean by the North Sea spine either, as it will certainly not be superconducting (at least in the scientific sense). To my knowledge, there's no idea for a spine as of yet, although it has been proposed the various windfarms could be interconnected, thus also connecting various countries at the same time. However, it's very much at discussion phase at the moment and far away from reality.
As to Scottish Indy. Well, your glorious leader (Sturgeon) is both a rabid racist (her constant abuse of the English in rants) and hated by quite a lot of the Scottish as well. I've met many a Scottish person who thinks she is the worst thing to have ever come out of Scotland. Now that the oil is drying up, good luck if you choose to leave, but you'll be doing it outside the EU (despite her claims), as there's no way you'll get membership, which the EU itself has said (you have to apply like anyone else). And, everyone knows the French and Spanish will refuse the application, as they're scared stiff of their regions doing the same (Catalonia, Basque etc.).