I have used NVG in very poor vis to get the required visual references at the bottom of an ILS once - not pretty or clever but we had no diversion options and a sick patient on board. You could see the lights at DH with the goggles but not without them and it was a two-pilot process.
Agreed. The transition from instruments/IMC to visual landing at night at/near ILS mins, is one of the most challenging maneuvers of IFR flight. The high intensity of the approach light system and runway lights can penetrate cloud and fog at the distances involved near DH. This amount of artificial lighting is sufficient for adequate NVG operation. It seems odd one could understand the benefits of NVGs, but dismiss their value during this phase of flight.