Well, Nikon doesn't make a p5000 so not sure what you were looking at.
Looks like the g7 runs 4 to 5 hundred but you don't mention a price range.

If you go to this site http://www.dpreview.com/reviews/compare.asp anc check off the features you want it will give you a list of cameras meeting those specs. Most of the better point and shoots have macro and optical zoom of various powers.

When you get the list, there will be a list of specs and you can pick a few of the ones that seem to be what you want and then look at their full reviews, focusing on those things that interest you, such as the macro capability or low light. If low light is important I'd look for something with max shutter of 2.8 which the g7 has but not sure about the others.
There is also a glossary on site in which you can look up terms, though even the definitions can be somewhat technical.
Those with more expertise than I will probably have better advice.