Well, not you really- but your children. Most children go through a stage where they're afraid of the dark. Our daughter has, and we've resorted to night lights to try to help but have had mixed results.
First, we borrowed the somewhat ubiquitous Cloud B Twilight Turtle from a neighbor and our daughter loved it so we went ahead and purchased one. Well, once she actually became more afraid of the dark- she wasn't really interested in the turtle.
We also tried the Spoka from IKEA which our daughter seemed afraid of and asked to keep it in our room.
Right now we compromise by keeping the hall light outside of her room on and shutting it off sometime later after she's fallen asleep.
What is your child's lighting situation at night and what has worked for you to ease any fears?
(Image: Rainbow in My Room via Gizmodiva)
Before & After: Emily Henderson Transforms a Senior's Studio Space
Monica & Austin's Charming Bungalow
Good Food to Share 
The Big Book of Small, Cool Spaces 
Apartment Therapy Presents 
The Eight-Step Home Cure 
White Enamel Four-P...
How to Make Easy 3-Ingredient Energy Bars at Home
True Greek Recipe: Paximadi Bread Salad with Tomatoes, Feta and Capers
I got a light bird (Circo) for my daughter after she messed with the plug-in night light. I was afraid she would shock herself, so I switched to this rechargeable light. She loves the light bird, and takes it with her every she spends the night. We have now gotten a light Monster (also Circo) for my son.
They are still available and even have other shapes. Mushroom and polar bear.
we bought our 3 year old a little dog night-light from target. She loves it, but still refuses to turn the light off in her room. We generally turn it off after she's asleep. I've just accepted that she'll probably grow out of it...Until then we just keep the energy-efficient bulbs in her lamp.
We found a flashlight much more effective than a nightlight--kept next to the bed it allows our daughter to light up the room if she wakes up and feels the need. That, a stuffed monster doll, and some "fairy mist" (essential oils and water in a spray bottle) keep her feeling safe in her room at night.
We bought our son a pabobo giimmo dinosaur. He was afraid of dragons hiding in the dark. He calls the dinosaur his dragon and it seems to have changed his view on dragons and also given him a light in the dark. He can tap it on and off so once he is asleep we tap it off, but he can turn it on whenever he wakes up. (I should mention, it's battery operated and doesn't get hot) We didn't like the idea of a night light for two reasons: 1 is that with a nightlight on at all times, it was likely to effect his sleep and whether he stays in bed or gets up to play, 2 is that they plug in and he might tamper with it.
Yes, we do, and the light is tiny. The LED nightlight in the bathroom is much brighter because you do kind of need to see where you're aiming (boys standing up to pee). The other light is a Moon in My Room, which turns off after half an hour; it's just for fun and does not stay on.
we use the moon shaped wall pendant from ikea with a night light bulb. it casts enough light to see well enough in the room, but is still subtle enough that it wont keep your kids awake. we love it.
We got a super cheap plug in the wall LED nightlight from Walgreens that rotates through all the colors. It's very basic, but actually very cool.
I remember reading about a University of Pennsylvania study linking nightlights to myopia in kids a few years ago. I think a subsequent study said there was no link. But, my conclusion was not to have a nightlight in the kids' rooms to start out and I guess I'll add one if they become afraid of the dark later.
We also have the blue bird light from Target also. Hannah is not afraid of the dark right now, so we don't really use it, we used it in our room while we were co-sleeping during frequent night nursings.
I don't blame your daughter for being afraid of the SPOKA. looks pretty creepy to me!
We use an LED pillar candle for our son. He has a twilight turtle, but just plays with it. I love the fairy mist idea!
We actually have a touch lamp in the nursery and we use it on the lowest setting all night (we do this in our bedroom too) I purchased them after posting a question on OHDEEOH before my son was born. It was a nickel set from BB&B that they no longer carry. Not sure what I'm going to do when these fizzle out....
If your child has suffered from night terrors, my husband read recently that one of the few things that have been found to help is leaving a full light on. We're only used this on nights when our son has suffered from them, but it HAS made a difference. We leave his overhead light on 1/2 dimmed. This is a kind of a tangent, although I know many of you out there are dealing with it!
Fairy mist! That's an awesome idea!!