In a UK democracy, Scotland is less than 10% of the vote based on population.
I stand by smaller, more local denominations of power and decision making. Where policy can reflect local interests. This does not preclude Unions on shared topics, where one is happy with a 'foreign' leadership. If Scotland was happy with UK healthcare, for example, there's no reason they couldn't contribute and remain a part of that system - if they wanted to.
I stand for voluntary Unions where common interests are shared on a mutual basis. In contrast to compulsory Unions made by force. I stand by Democracies small enough that you can protest your capitol and sleep in your own bed later that day. Where your voice is actually heard and not drown out by thousands of miles or hundreds of millions of other voices.
The United States is a prime example where 50 States deserve a greater share of power. This is how our Union was formed, with them being more responsible managers of their own affairs. Over time we have eroded the rights of our local representatives in favor of centralize power. In the past hundred years we started collecting taxes straight from the people to 1: bypass the States, then 2: to enslave them with this money. Federal funding means federal ownership, which is pretty much everything these days.
There are separatist movements the world over. Scotland did not win today, but they didn't need to. There are plenty of other opportunities for the next stage of representative government to take shape. I say nothing lasts forever, because no Union ever has. It's just that we folks in Western Civilization have, for the time being, put down the use of force and decided to discuss these things. It's a slower, but hopefully better process where we try to keep both civility and our interests.
These modern secession movements are a test to see if the human race is ready to be civilized. Civil enough to let borders change without bloodshed. It is a trying time, it is our nature to use power - to use force to control others. It must be very tempting to simply shoot and take. It would be very good for our species if we learned not to be unnecessarily violent. If we learned to let changes happen and to let people form Unions as they see fit.