Buzz, it's not so much about MP, as it is lighting
and the size of the sensor chip in the camera. Small
compact digital camera use a ton of software inside
to account for the small sensor size, but there's only
so much data it can gather in each pixel.
This site [below] has some superb tutorials that will make any
photographer, beginner or pro, better at getting the
image they desire.
Cambridge in Colour - Photography Tutorials & Learning Community
If indoors, DO NOT use fluorescent lighting (ie: CFL lamps)
unless your camera has a Color Temp. setting that specifies
the correct color temp. A flash used in a macro setting, if
directed at the subject, will often leave a "bloom" or bad spot
of light on the image.
Bouncing the flash off of a piece of white foam, or even
a wall will get rid of that bloom. Better yet, take the pic
in sunlight.
I enjoy "fixing" pics for others, so if you have a shot or two
that need some help feel free to PM me and I'll do my best to
get them right for you.