I feel your pain..........I have a double 8' fluorescent fixture above my work bench and seven more in my garage. But more and more I use a powerful LED flashlight to aide me with closeup work. I think DFW is on the right track with a fluorescent lamp with a built in magnifier ;^)
About a year ago, I bought a two-pack of those LED lights that have elastic head bands. I thought they were goofy, but I was working alone on one of my hobby cars and gave them a try. I figured I could always just toss them if they didn't work out. Well, I found they were great and left both hands free to fumble with whatever widget that needed my total attention.
I was in Home Depot or Lowe's recently. Both stores had a section of hand tools for Christmas stocking stuffing and they had those lights for less than $10, if I remember correctly. I bought another set. Just make sure they have elastic bands that go around and over top of the head.
If it's stupid, but it works, it ain't stupid.