Most of my work is turning - in an 8x6 shed, with a lot of stuff keeping me close company! A powerful directable pool of light source has always been high on my list, preferably one I can move from lathe to grinder etc fairly easily........
I tried an old anglepoise - very focussable, but the arms were too long! And actually not nearly as 'flexible' as I'd imagined. Tended to get in the way.
Tried a modelmaking "through the lens" magnifying light with the anglepoise type arm(s) - great idea but awful execution. Almost impossible to position it simply in one movement - too fiddly, too light? (pun not intended!)
I bought a mag based gooseneck mains LED - works well with the bandsaw but not much else - too awkward (or maybe I am!). Too many round surfaces on the lathe for it to get attracted to. Also doesn't have a great light (watt?) output - fine if focussed, no good for a wider use.
In desperation I bought a goosenecked (I mean a flexy metal tube stem) reading lamp from John Lewis - in the sale of course! - nailed it to the wall and it does the lathe lighting a treat - very precise, small head so not obstructive, etc etc. Well pleased!
Waiting to find out if a well s/hand old engineering lathe light will also do the job (no point in mucking about with the JL gem, but the sawdust/sanding dust will clog the metal neck solid sooner or later!) - looks quite a lot like the Axminster £50 jobbie referred to above.
So - at last! - my recommendation is be prepared to try several - borrow to try? - solutions to find the one that works for you. Nothing worse than not be able to see properly what one is doing!