I have read this thread with interest, it has been extremely interesting! 
I just wanted to comment on SNP scots being 'anti-english'.
I married a scot, we live in London. When I first met DH's family over a decade ago half his family were lovely, the other half made lots of jokey digs about my Englishness which I took on the chin, but although they did make me feel uncomfortable it was quite easy to 'banter' back.
Lo and behold the lovely half of DH's family are sad about brexit but massively pro union still and devestated about the divisions, incidentally they all very much dislike sturgeon. The 'jokey' lot love sturgeon and are frankly getting more 'racist' by the day.
One of them had the cheek to say to me that 'scots are not racist like the English, we actually like immigrants'. Just as an aside the vast majority of my workplace are immigrants (and not just from Europe, Kenya, Australia, New Zealand, South Africa, china, America etc are also represented) and I love that, have met some lovely people and honestly am really pro immigration. I voted remain, but honestly can't see immigration stopping with brexit. I was actually really upset by that comment. I grit my teeth and keep my mouth shut now when they talk about how much better Scotland will be when not shackled to the English. Incidentally not one of DH's SNP supporting family works with any immigrants. They are well off live in this angry victimised bubble as far as I can see.
I hope Scotland remains in the U.K. for the sake of the lovely side of my DH's family. But I'm so sick of the bloody SNP!
Wow that was cathartic