Just wrote a test app on macOS that initializes the camera, gets the first video frame, and turns it off. You definitely notice the bright green LED being on for a split second.
You only notice it immediately if you're looking for it. I've gone minutes with the camera on before noticing the LED while I was distracted by other stuff on the screen.