For all the recent scaremongering about the viability of an independent Scotland, it's easy to understand why the chance to reclaim a country's sovereignty offers its citizens an exciting prospect.