We'll have to see if the D800 is the perfect camera for that can only be assessed in hindsight IMHO.
I have had many cameras and some of them have been perfect:
- Nikon FE - perfect in 1979 - rugged, easily controlled, reliable - Bronica ETRS - not perfect for me - heavy, slow, no meter - Nikon n8008s - perfect for 1993 - auto focus at last - Nikon D100 - perfect - finally a dSLR I could (almost) afford - Nikon D300 - a great step forward, but not perfect for me - Nikon D700 - perfect - better than Kodachrome in every way, high ISO
So, the way I see it perfect is based on continually changing expectations. I expect the D800 will be perfect for many for the time being but don't plan on it to be perfect forever.
For now, I have my latest perfect camera and will continue to push my abilities so that I can approach it's power to record images to its potential.
It's easy to loose track of but in the end the perfect camera is the one in your hands with your finger on the shutter release button not the one behind glass at the camera shop.