I'm using my D800e for mainly photographs of people, corporate stuff - that sort of thing with a 24-70mm lens, 70-200mm or 300mm, or even the 16mm Fisheye-Nikkor for some group photos of people working at their desks.
It's pretty damn good and I haven't had issues with the moire patterns yet.
I would highly recommend the D800e, if you can find somewhere that has it available, and if it suits your requirements.
Take note of the Nikon warnings from the D800/D800e technical guide, the high megapixel count amplifies even the slightest blur, and also you should be very watchful of depth of field blur. It also demands the sharpest lenses for best results from my experience so far.
I find also with the D800e I do very little sharpening - and I can crop the images massively if I need to and still get great results.
This is just my observations after a short time of having the camera and based on what I use it for. I don't know how you'll use yours, so your mileage may vary.
But having it already, I've become very aware that a whole lot of other pro-photographers are absolutely desperate to get their hands on the D800e, I've had quite a number of them ask how I managed to get one so soon in this country, and where did I get it from, and total disbelief when I explain that I didn't pre-order it. That should give you a hint at how highly sought after it is.
