my take:
Canon 60D and other APS-C DSLRs: lots of moire
Canon 5D2: still lots of moire, but not so much
D800: still some moire, but a lot less than 5D2
5D3: no moire
D800 has serious moire in 720p mode like the older Canons. It really looks quite bad especially when stopped down a bit. In 1080p it's ok. It's there but avoidable.
In the D800, the filter blurs fine detail slightly, on purpose, to ward off colour problems such as moiré. In the D800E, the filter's blurring effect has been nullified. The result should be more finely-detailed photos from the D800E, accompanied by an increased prevalence of moiré swirls in fabrics, patterned objects and the like. The D800E's probable fine detail upside comes with a potential colour artifact downside, which is why Nikon is touting the D800 as the standard version and the D800E its more-specialized counterpart.
@ kaushalsingh, were talking about the moire in video mode, which is quite the same between the d800 and the d800e, thats why a extra filter can be beneficial to combat these aliasing occurrences.