None of our outlets at home are in the right place for a night light, but we would certainly use one if we could. They're especially useful when entertaining overnight guests, who may not be familiar with the layout of your house, in order to avoid unnecessary bumps and falls. The night light above was — awesomely — repurposed from a Chevy taillight (by 8milecreekdesigns).
This light by FogAndThistle is a papercut, but the design only shows through at night when the light is on (bummer, it's a beautiful design we wouldn't mind seeing all day).
The light above is great inspiration for a DIY project; it's made from a punched and painted tin can by MariposaAvenue. It has the opposite problem of the one before — what makes it special is the bright red color, which, since it's not transparent, is all but hidden at night when it's lit.