This thread is making me wonder what everyone considers an ideal camera for their work. Sounds like Colin, Adrian, and Manfred might all make good use of medium-format digital systems from 40-200MP, depending on print dimensions. Naturally, high-ISO performance (which I consider vastly more important than diffraction limits or resolution) is the drawback. The costs associated with these systems are coming down, so I don't think it'll be terribly long before they're viable competitors for high-end 35mm SLRs. Or maybe they already are.
Personally, a 10MP APS-H or 35mm DSLR with 10MP and 10+ frames per second with weatherproofing, dual cards and solid performance above ISO2000 up to perhaps ISO5000 max would be perfect. Web and editorial publishing make life a lot easier, resolution-wise.
That said, I've blown 12MP images up to 20x30in, and been reasonably happy with the results. But I's probably be displeased with a print that stretched resolution more than that (142dpi). Guess I'm picky.