In general, I oppose nationalism and dislike the concept of the Nation-State. If there was a federal European state for Scotland to join as an semi-autonomous region, I'd almost certainly be in favour of it doing so. However, the alignment of the state with the nation is a poisonous anachronism that has no place in a modern globalised society ¹, and virtually any move toward that in a free state seems regressive. By all means hold onto whatever regional history and customs inform your identity, but don't make that part of your governance.
For the avoidance of doubt; my internationalism is firmly based on democratic free association. People living in a reasonably definable region² have every right to choose their association and governance, it shouldn't be enforced on them. I'm entirely happy with the idea of a Scottish independence referendum being held. I just think the vote should be "No".
¹ Where the larger state doesn't offer a good degree of freedom, it is probably better to be a free nation-state than part of an unfree federation. Free Tibet! (with every hackneyed joke).
² …obviously, that's the detail containing many of the devils.
(If anybody feels like playing a game of asking me what I think about many other national independence situations around the world and in history in the hope of catching me in an inconsistency with the above position, please don't. You probably will succeed but it'll be dull and take more time than I want to spend in the argument.)