Clinton's foreign policy approach to Northern Ireland was a resounding success. Even his harshest critics were amazed at the love the former president received during his trip to the region, and the peace agreement was largely a triumph for the Clinton Administration. The US continues to be a positive influence in the nation.
The US has its own economic interests, and although it holds a commitment to peace in Ireland, America will ultimately seek to advance its own goals. There is no obvious reason for the US to take sides in the current Brexit-fueled dilemmas surrounding the region, and no one should count on the country to support Ireland's interests, despite America's diplomatic success there in the 1990s.
There is a 41% chance that Northern Ireland will hold a reunification referendum before 2030, according to the Metaculus prediction community.