On a hand held point and shoot camera, anything above 8-10 megapixels is useless, because any camera that advertises higher is simply enlarging the image digitally.
On a DSLR, it is now common to get up to 20 megapixel camera (full chip e.g. Canon 5D), but if you want to go higher than that...