Lucas Herbert has overcome a four-shot final-round deficit to win the NSW Open and deny his superstar LIV Golf teammate Cameron Smith a first victory of 2024.