I use a D800 for wedding photographer and i know of another photographer who is using the D800E.
He has said there is no difference and he cant tell the moire effect is prevailent.
I love the D800 and using it for photography and cinematic video wtih glidecam, sliders...
The quality is amazing. Yes some people complaineda bout the greenish tinge but it was fixed easily enough.
One thing that Nikon has over Canon is AUTO-FOCUS during video. massive plus especially for us guys who do HD video with glidecams