I would like to get some opinions on what options there are for doing some macro work. My wife would like to get a camera that she can use for some macro photography. The size of the objects would be half the size of a regular post card and static. We did not yet think about the lighting but most likely we will use some constant light source, so macro flashes are not required.
I have got a D700 but this camera is too heavy for her. As macro lenses I have got the 55 mm f/2.8 AI-S and the AF-D 28-105 mm f/3.5-4.5 which has got a Macro mode and takes good images.
The next things I was looking at are the entry DSLRs. I borrowed a D5100 and from the size and weight it is fine. But I could not find any zoom lenses with a Macro option. I know that there are the 40 mm and 85 mm Macros but we would prefer an zoom lens. Another option would be the D90 as we could use the AF-D zoom lens but I don't know if getting the D90 now is a good idea as it is kind of dated - or am I wrong?
The Nikon 1 system would be another option but I have no idea if the lenses do have a macro mode. I could not find any information on that. Using the adaptor to attach a F-mount macro lens is not an option for me. I think for the price of the Nikon 1 plus adaptor I could also get a D3200 or D5200.
The last option I thought about is a good P&S like the Coolpix P330.
Any other ideas? How would you spend my money (currently we don't have a fixed budget but we want to keep it reasonable).