My personal MP/resolution requirements are based on what my printers need me to supply for optimum results.
I wear two hats (at least). Firstly professional print design, where photographic images might be printed using offset litho printing. This requires that images be around twice* the resolution of the halftone screen, at the printed size.
So for my use (your milage may vary), the following applies.
For a newspaper, (printed on newsprint) which often only uses around a 65 lines per inch screen (for example) the supplied artwork may be as low as 130 dots per inch. So that's about 1.7 megapixels at A4 size.
However, if I am using an image for a full colour glossy brochure, which can use a 225 line screen. Perhaps even 300. The image needs to be that much higher resolution. For a 225 line screen, I would need to provide an image at around 450dpi (around 20 megapixels). If it was a high-end publication, I would probably provide it at an even higher spec. For an A3 double page spread, that could rise to around 80mp, in theory. Which is where medium format comes in for fashion shoots.
When I supply images for exhibitions, the supplier that I use for high-end inkjet output wants images at 360dpi. So, for an A4 print, that's about 12.5 megapix. For A3, it's closer to 50mp. In practice, because gallery images are generally viewed from a bit of a distance, I've found it perfectly safe to use 270dpi (around 28mp at A3) in the past.
Of course, it's often possible to get away with much less than the above. I don't do fashion shoots, but I wonder how many fashion phtographers have access to 80MP cameras?
But, for me, one of the reasons that I chose a Sony Nex 7 and then an A7, is because of the 24mp sensors. It gets me as close as I realistically need to the amount of data that I generally need in my photography. An A7r would cover even more bases, but as I only hand-hold when shooting, I thought that the A7 would give me a more reliable result. (From what I've read, an A7r – like the Nikon d800e – would come into its own more with tri-pod use).
A couple of useful links:
http://web.forret.com/tools/megapixel.asp
http://www.designtalkboard.com/tips/dtp/dpi.php
* Actually the traditional recommendation is generally 1.5 to 2.5 times the halftone line screen. Below that, the image has the potential to appear pixelated. Above that, there is no noticable increase in quality and at very high resolutions, might even begin to look less sharp.