I'll second the recommendation for the PALight/Safety-Light flashlights. 9volt is a bit of an oddball battery, and it wouldn't have been at the top of my list for most purposes, but it works great with these lights.
The thing I like best about them is their extremely low "always on" level - great for a nightstand light. You don't notice that they're on when there's a light on in the room, and when the lights are all out, it's enough light to easily find the flashlight on the table top without disturbing your night vision or being an annoying source of light when you're trying to sleep. Then you can use the light as needed. Even on its highest setting, it's not what you'd call a terribly powerful light (LED technology has really leaped forward from when these lights first came out). But they're very useful lights.
One tip I got from CPF back when I first got my PALights - they come with a plastic lens that focuses the beam a bit more tightly than I find optimally useful - the tip was to pry out the lens and reverse it, so that it's got a broader beam. I prefer my lights that way - it might not be everyone's preference.