I'm pretty new to the Nikon scene but I really like the look of the D800.
I was a Canon shooter until recently and I remember when the 5DII came out everyone ( including me ) was going on about how noisy it would be. The truth turned out to be that it wiped the floor with the 12mp 5D in terms of noise performance and to my eyes is pretty much as good as the D700 in this regard. I read the Mansurov article and it seemed reassuring too.
I've also noticed quite a few comments on other sites about the price being high. I don't know about anywhere else but it's launch price is the same as the highest price the Canon 5D mkII got to here in the UK. Seems pretty reasonable to me.
Really the only downside to my mind is the file size which is a bit on the large side for processing and storage. I'd put up with it though
I'm still very happy with my D700 and I'm not going to buy the new one yet ( can't afford it ) but it certainly seems to be an absolutely stunning camera and I'd love one!