I'm not really sure I follow - the NI and Ireland example seems like a poor one because of the political history.
Why is a hard border unworkable in the Scottish case? I could definitely imagine this is true, e.g. if Scotland has to import much food or other goods. Or because Scotland depends on the pound. And maybe, in that way, it shares some parallels?