(I'm answering based on the thread title)
imo, as long as you know how to work with the cameras you have, any camera can take a good photo.
Case in point:
The photo that I took in the 2010/2011 New Year's competition was taken with a 5 megapixel camera. It got me third place. You don't necessarily need a good camera to take a good photo. You just have to know how to work with it.