People want stability. But there is definitely a strong sentiment for unification. It won't happen, however, until bigoted organizations like the DUP are completely removed from power and attitudes change over time.
The last time I was in Belfast (a couple of months ago, actually) I asked a Sinn Fein sympathizer---whose dad had been in and out of prison for years for his involvement in the RA---whether he ever expected to see unification in his lifetime, and he told me that if it happened, it would be right before he died.
Generational change is really slow and for things to work out the jingoism needs to die. That, in essence means that for things to work out, anyone with any memory what-so-ever of the Troubles will have to be long gone before unification.
And if this slow process works, the IRA will have won because they are the ones who ended the status quo and forced Britain to make the concessions which allowed for peace. And really, it's almost contradictory that the IRA would win its first objective through a long-term peace.
But you can have the most optimistic view imaginable and have it completely ruined by just visiting Belfast on the 12th of July.