This is an interesting point and one that deserves some thought.
In the olden days (during the troubles) there was a certain resentment, those days are long gone.
In my own business a great many of my customers are retired UK folk having moved to the Irish Republic. I asked one N England steel worker why did he choose Tralee, Co. Kerry. He said it was a toss up between the Costa and Ireland, apparently the locals decided it for him.
I hear similar stories most every week, last week it was a man from the South of England - he was telling me the best pub in the area of Co. Cork that he now lives in, “tell them the big Englishman sent you and you’ll get looked after”.
In July last year we went into a small country hotel in Roscrea, Co. Tipperary. After check in the usual destination is the bar, it was lunch time and the large TV screen was on. There was a huge roar coming from the bar - somebody had scored - it was England in the world cup.
Some of my family just back today from a birthday bash in England - their only rule was no Brexit talk - that i liked.
Anyways to the question - will there be a hard border? - all those who are saying no are politicians - even the leader of the DUP said recently that there was never a hard border (see my pic Feb 6th) - most people locally take what politicians in either UK, NI or ROI with a large pinch of salt.