Not a fan, but it's not really my concern.
I am not Scottish nor have I ever been to Scotland, so I have no strong feelings either way. But I would say that the Brexit results and rollout has made me more sympathetic to the independence movement. If I had a vote in the 2014 referendum, I probably would have voted no because Labour would have lost seats in parliament. Now that there is going to be a hard Brexit taking place which Scots voted overwhelmingly against, I'd lean in favor of independence if a second referendum were to take place. That is assuming Scotland would be accepted into the EU.
I don't really think being in the EU with a hard border at Berwick is a more desirable deal for Scotland than staying in a non-EU UK, but there could be something I'm missing.