I use this lens on a 12mp D700 and think it's great.
You see, there is - at least to me, the whole big issue here? What is your need, your purpose, your workflow. I use the 24mm F2.8 on my D700, and love it. I don't like it on my D800.
However, I use those two cameras for very different purposes. For a photograph that appears in a newspaper, where your max resolution is 300 dpi on average, the D700 is all you need. Big a big print hanging on the wall, out comes the D800.
When it comes to talk about these lenses, you almost need to say ahead of time what your purpose and need is for it, because I think that makes all the difference in the world.