One that I haven't seen mentioned ever was neat flashlights in every hotel room I stayed in. They were all mounted to the wall, and had no power switch. The wall mount had a tab sticking out that separated the batteries, so when you went to use it, the batteries touch and make the circuit. They were always low power, so that you didn't disturb others in the room, and you have to keep it in its location to turn it back off. They worked well for going to the bathroom at night and not messing up night vision too. I tried finding one in the US, to no avail, but they're all over in Japanese 100 yen stores. A clever, cheap design.
It's just a slightly different design on a standard flashlight. I was able to find this, seems to be a manufacturer of them. Hotel torch they do seem to be mostly for emergencies, but would work well enough to be a night light
Similar in that it's mounted, different in that it has no buttons/switches and wouldn't be on, or even able to be on when mounted. Those look pretty cool though.