I was at a concert yesterday and wanted to take a picture without a flash so I set the applet for "no flash" and then set the Scene Mode to "nighttime".
When I went to take the picture, the N97's camera during the focusing turned on the LEDs briefly. The didn't flash, but I would have expected the LEDs to not have lit up at all.