I was doubtful about NVGs until I actually started using them. Then I wouldn't consider going out at night without them. Most HEMS operations in the US use NVGs for night flights. I don't use them all the time, often flying with them flipped up, but that's in cruise flight at altitude. Down low, they're essential. They can be used in situations with high ambient light, such as lighted pads in cities with all sorts of lights. I don't usually use them in those places because there is so much light that it's easy to land unaided, with more peripheral vision cues. But current generation NVGs are not affected by bright lights, to any major extent. They can bloom slightly when looking directly at a very bright light, but they're still usable. It takes some training to be proficient, like any other maneuver, but it's not that difficult. I see no reason at all that they couldn't be used on offshore rigs. I've done many hundreds of night offshore landings over the years unaided, and I would hate to go back to doing that without goggles.
Regulatory oversight is problematic. The FAA really has no clue about NVGs, and their regulations and enforcement make little sense. It's obvious none of their inspectors have ever used NVGs seriously, only a few flights in a training situation. Regulatory agencies in other countries probably have even less experience. Current FAA regulation actually makes operations less safe than they could be, and that may be the case elsewhere when (not if, when) NVGs are adopted there. They're coming, technology cannot be denied forever, and they're a very good thing.