I spent 4 years in Scotland and 2 of my brothers live over there... I've often planned to go back permanently.
I'm not massively invested in the vote but my balls say no. That's just my personal opinion... as a Northern Irish Roman Catholic I don't have the most natural of dispositions towards Westminster or England, but i'm very proud to be a part of the UK, I'm equally proud of my Irish heritage but the two go totally hand in hand as far as I see, despite the past and what others would say.
If someone offered me a United Ireland tomorrow I'd lock them up in the looney house... We draw so much from the Mainland and the prosperity of N.I is inseparable from England, I don't see any reason why I'd want to disturb that, conversely it's a tremendous source of pride and enables me so much more, in my experiences.
Scotland is totally different though, it doesn't have the recent religious/war history that muddies the water and equally has a lot more going for it in terms of independent stability than N.I, larger/oil etc.
Will it actually be any better? Better the Devil you know imo... Salmond want's his slice of history and not much else - the upheaval and uncertainty would concern me... which political parties would rise and fall and would they better represent Scotland? It's far from sure.
Scotland already has a very fair level of Devolution and some of those wanting to lay all fault at Westminster's feet are as much part of the problem - that's politics though.
Broadly i'm concerned that a very good and aggressive campaign (I personally find the yes stickers & badges very poor taste and faddy) will carry a lot of people who aren't necessarily concerned with the Pros and Cons but drawing from a stroked sense of nationality and a kind of almost selfish, I can change the future for the sake of it, kind of approach. It's something I can really understand but it's potentially dangerous.
I'd rather they didn't separate, I'd be sad... but I think, much like Ireland when you go to Scotland you know you're in Scotland... it doesn't feel at all like England, there's a very separate and different culture and identity, they'll probably do a grand job of it in the long run.