Well about light, my bench is 10 feet wide by 3 feet deep, (for us in EU is 3m by 1m), I've 2x1.5m T8 25W 6500K side by side to cover the bench, got plenty of light here.
I've one tripod here that a friend of mine that is doing some hobby photography on the weekends gave me, heavy robust aluminum tripod, I'm also making a soft box about 2x2x2 feet, to shoot inside.
I agree that if you don't know how to shoot the pictures gonna look like crap even with multi dollars DSLR, but if you know even with low cost P&S you can do good things.
I know that with $200 you can't buy a DSLR + Macro lens, I was thinking $200 for DSLR, I've plenty of space and can leave the DSLR always setup on the tripod pointing to the softbox, I know that with an P&S it's more portable, less time in setting up. (I have to buy one new also to shoot on vacations)
My intention with this thread was to make some kind of dummy guide for the ones that don't understand nothing about photography of repairs or PCB's, and think that with only Hi end gear you can do this, and not on the cheap side, gathering information about some DSLR and P&S, and also about Macro lens.
Some cameras talk here has been;
DSLR
Nikon D200, D90, Canon EOS 600D, Sony NEX, Sony SLT-A58
P&S
Canon A800, Canon Ixus 800IS, Canon SX260, Panasonic Lumix DMC-FX77