I agree with Susana, its all about the lighting. If i were photographing smaller items Id still probably use my SLR since I'm fortunate enough to already have one handy, but my experience with smaller point and shoots has been great still.
Even with a poor camera, a tripod + proper lighting can help make your pics look a lot better.