I think it will be good for two reasons. First, it will make UK governments more accountable to their voters. Second, it should make us more outward-looking and internationalist. (I realise many Remainers think the opposite, and some Leavers wish the opposite, but I think it's true.)
However, it all depends what we, and successive governments, make of Brexit. As someone else commented, it will be a long time before anyone can say with confidence that Brexit has, or has not, been a good thing.