As the resident Scot I can tell you that it actually is the Tories driving this. The legacy of Thatcher in the 80's destroyed the Tory vote up here (fun fact, Scotland used to vote fairly Conservative before the Demon Grocer of Grantham). For me, and most people I know, voting Yes on Thursday is about never having to suffer another Tory government.
In American terms it would be like having a referendum on never having another Republican Congress, Senate and Presidency. Knowing this board a fair few of you would be quick to vote yes on that.