I have the Stanley tripod flashlight at home in my tool box. Nothing works better when you're digging inside your computer or wedged behind your TV trying to plug in that new DVD player you got for Christmas!

One nice feature is that the batteries store inside the legs you don't need them to be full for it to operate. If I need some extra AAs in a pinch, I can steal some from the flashlight and the light still works.
If they ever get cheap enough I'll put some in the cars for that tire change scenario. Headlamps are good but if your wife/buddy is helping you and there's only one light (and it's attached to your forehead) it's less than practical for them.
I got mine with a bonus keychain version. It's just a single LED light that runs off of a small coin cell but it's surprisingly bright, has a decent reflector, and the tripod comes in handy. I leave right on my computer for when I need to quickly duck inside the case or under my desk for something. It's too big and awkward (IMO) to be a keychain.