We all made assumptions so I will "Bend" it a little differently...
I looked for "spot" lighting since Mike referenced that mag base LED light - It is what
I needed... (read: assumption - if you show me a picture and it is what I need I will show you what I am thinking of to fix
MY problem)
I already have a large 60 or 100 watt swing-arm lamp
and overhead fluorescent, finally bringing me to my too-long-winded point.
I studied lighting a LOOOOOG time ago and there is a balance of overhead and or indirect light in room. There is math to understand the combination of all three of these which I have long since forgotten, but all in all think
blended "High" light typically florescent (even reflective if you have a white ceiling) and then work space lighting - the old two bulb florescent over the work bench and last LED or incandescent as task lighting.
The blending of the three is what makes it work... and it IS personal - what works for you may not work for me!
Last - I always think budget - I could but wouldn't afford a Moffett - that $100 can be spent on wood or more tools (My wife thinks I have enough, but I am sure there are more out there calling my name!)