Yes, most of the Scottish people I have known have not liked us (didn't mind living here though, of course). Think they would struggle to survive independently, as the Barnett Formula works very well for them.
I also thought the last poll showed the majority of Scots were in favour of staying...