George,
I have always really liked the IKEA knock off of the clamp-down anglepoise lamp for this purpose, I think they're called "Tertial" and hold up really well.
You can use them as is with 240V, or if you need the extra safety of low-voltage, the power demand of a Modern 12-24V LED bulb is low enough for the cable in the lamp to still be suitable, so you can cut the plug off and wire it straight into a cheap and cheerful low voltage lighting power supply.
Not as cheap as Dave's find, but you're also paying for a lot more material.
That said, I find it much better to have good lighting design for the whole space, which with the genesis of unreasonably cheap LED Battens and Panels is much more realistic and affordable than ever before.
Since I replaced the old lighting in my workshop, and took the time to design a lighting setup which gives me option to have 500, 1000 or 2000 Lux down-lit illumination evenly across the whole workshop at the flick of a switch it's extremely rare that I need machine lights anymore.
Hands down the best £200 I ever spent on the workshop.
Edited By Jelly on 30/10/2022 15:52:27