I supose it is too late, and it is not so sruprising n this forum that all the discussion was about landscapes, but I have been thinking about resolutin and pixel neds for macros.
To put it positively, don't worry about it; once you have the resolution for big detailed landscapes, you should have more than enough for macro work. Loosely, big, wide distant scenes are the easiest ones for getting lots of detail with adequate DOF, while small, close subjects are teh greatest resolution struggle.
Once you stop down to get adeqaute DOF in a close macro, say f/16 in 35mm format, you will be significantly diffraction limited with the 16MP 1DsMkII according to observations reported by Jack F. in this forum, and backed by the math on diffraction spot sizes. At an estimate, you will not gain much visible detail beyond 11MP, due to diffration. Even 8MP is probably fairly close to as god as it gets. (Changing formats does not change the diffraction/DOF trade-offs on resolution, once the lens limit is those factors rather than lens resolution.)