For ultra high-end commercial shoots, a medium-format digital camera (~40MP, typically) might be desirable. But that's for when something needs to look tack sharp on a 7'x4' poster, and even so is arguably overkill for all but the highest end applications.
In reality, a 5Dmk2's 21MP 35mm sensor is more than adequate for any reasonable enlargement at the professional level, for reasons already mentioned several times in this thread.
Same with 18MP, but on an ASP-C sensor (e.g Canon 550D, 7D), it's actually suboptimal; fitting so many pixels on a smaller sensor means that each pixel gets proportionately less light. This can be remediated by tweaking ISO / shutter speed / f-stop ratios, made possible by using a better lens, but it is a limitation to be aware of.
I don't have much experience printing from lower resolutions, so I can't really comment on that. I'm inclined to think that 10mp is sufficient for semi-pro to lower-end pro prints up to 24", and 6mp up to 16". A well lit and well composed picture should look fine at those enlargements, although a trained eye could probably tell that it was shot at a lower resolution.
In reality, a 5Dmk2's 21MP 35mm sensor is more than adequate for any reasonable enlargement at the professional level, for reasons already mentioned several times in this thread.
Same with 18MP, but on an ASP-C sensor (e.g Canon 550D, 7D), it's actually suboptimal; fitting so many pixels on a smaller sensor means that each pixel gets proportionately less light. This can be remediated by tweaking ISO / shutter speed / f-stop ratios, made possible by using a better lens, but it is a limitation to be aware of.
I don't have much experience printing from lower resolutions, so I can't really comment on that. I'm inclined to think that 10mp is sufficient for semi-pro to lower-end pro prints up to 24", and 6mp up to 16". A well lit and well composed picture should look fine at those enlargements, although a trained eye could probably tell that it was shot at a lower resolution.