I use one which I think is the same as this - cheap & cheerful from IKEA, called GLOBAL:
http://www.ikea.com/gb/en/catalog/products/30018560/
It uses a narrow, long flourescent twin tube in a head which is lined with a reflective material. I've had mine in use for years as a clamp-on office desk lamp (I'm pretty certain it is the same model to that in the picture, or very similar). I recently promoted it to use on my workbench.
On my one, the clamp-on base can be separated from the upper parts (angle-arms and lamp). I used this to advantage by making a new wooden base which can be plugged into any of the 19mm dog-holes in the bench top. It usually sits in one of the rear dog-holes in the area of the front vice, but it can be moved to any convenient location on the bench.
I was recently prompted to set this up to get better close-up lighting over a saw vice (one of the scenarios you mention).
It isn't super-counterbalanced like a real anglepoise - it's a lightweight construction and simply relies on thumbscrews & friction to hold the arms in the desired orientation - but what do you expect for £14?
