Teardown of an LED plug-in night light. – YouTube
This is probably the more wasteful LED-based night light ever invented.
It actually uses more power when the light is switch off by the photo cell rather then on. And it uses big-fat 1-watt resistors to limit the current flow to the LEDs, producing upwards of 2-watts of heat, whenever is plugged in. Capacitive droppers are bad news, but resistive droppers are even worse, especially when your using 240 volt electricity with them.
The moral of this story: don't build electronics like this unless your goal is to burn more coal. It doesn't matter if it's only taking a few watts of power, you shouldn't go out of the way to design things as energy inefficient as possible.