You will definitely want something with a focus assist lamp (that will come on in low light conditions and help the camera focus), a decent flash & some kind of macro (or perhaps even super macro) mode.
Most half decent cameras have all these things. How close do you envisage being from the thing you are photographing? 6″, 1 foot……?
You might get better results if you buy some kind of wide beam torch to illuminate the area and use with the camera, as the problem with using a flash is it can make things look very flat.
I would also think about going for one of those ‘shockproof’, waterproof cameras if it’s going to be used in a workshop environment. Get it covered in oil – just run it under a tap with some soap, drop it on the floor, (probably) not a problem……panasonic do quite a good one:
http://www.panasonic.co.uk/html/en_GB/Products/DMC-FT1/Specification/2033769/index.html?trackInfo=true
It seems to fit the bill (although buttons look a bit fiddly if you’ll be using gloves). I can’t see in the spec whether is has an AF assist lamp, but it does look like it has an LED on the front which is probably just that. Worth looking into though, to make sure it does.
The flash is quite small, which might be an issue, although if you are taking close up pics it’ll probably be fine.