I've used a CMG Bonfire, hung on a hook over my toliet, for a nightlight. I also have some 110VAC strings of ForeverBright LED Christmas lights for nightlights. One string (with red, yellow, and green LEDs) is just jammed up inside a translucent frosty globe and plugged into a socket near the head of my bed, another string (all yellow LEDs) is wound around a phoney plant in the bathroom. Two strings (one with red, yellow, and green LEDs, and the other with all blue LEDs) are usually on in the computer area up near the ceiling.
Finally, there's a Digitronics LED nightlight in the bathroom, though it's a bit on the bright side for a nightlight (my opinion here, YMMV).