I would go with a Panasonic FZ28, FZ35, or LX3. Can not be beat for closeup/macro photography. Attaching the tube adapter + Raynox add-on lenses you have unlimited capabilities and can even reach magnifications typically only reached by using a microscope.
As for lighting, the 6500K Daylight CFL bulbs from Wal-Mart work excellent in the clamp on shop lights. An even better alternative is the same lights but use the Ott-Lite bulbs.