As someone from Ireland I'm really not sure I could be bothered dealing with all the shit that could entail. Would prefer if they just went independent and joined the EU as a separate country.
Unfortunately Northern Ireland doesn't have the economy or infrastructure to realistically function as an independent state at this point. You never know about the future, but it's likely not on the table any time soon.
Why does it need to be large to function independently? There are a bunch of far smaller nations in the EU/Europe: Luxembourg, Andorra, San Marino, Liechtenstein, etc. If Northern Ireland became independent, it could just join the EU (regular Ireland is also an EU member), so they wouldn't have to maintain their own currency at least, and would benefit from the free trade. If Luxembourg can function as it is, I don't see why Northern Ireland can't do the same.
This may be offset by the fact that Ireland will be the English speaking country in the EU in which multinational corporations can maintain a base of operations.