I am also Scot-born and like the previous poster, I loathe Flower of Scotland finding it facile and without merit in melody or lyric. How can such dirge like words be regarded as having an appeal to the better parts of Scottish people when the only person mentioned in it is a foreign enemy?
The appeal is to an outdated and outmoded bellicosity which has no place in an integrated and mutually dependant modern world. I knew that great songwriter, Michael Marra quite well and we shared out mutual disdain of the song. Not long after one of our conversations about it, Micheal sent me a copy of his recently completed song Hermless which he suggested as a suitable alternative candidate for a national anthem. In this live version, he says something about the song before singing it.

https://youtu.be/QtB65M_ejbA