Thanks for the replies so far. Yes I agree that we need an entire section on the forum devoted to Nikon DSLR video because there's no way a single thread could do the topic justice. But at least this thread could serve as a starting point.
Nice rig Glenn. I also want to get one of those Kirk L-brackets. I like how you set yours up to support the mic by itself and still be able to use the flash. You might think about getting an LED light instead of the flash? I'm a Manfrotto fan as well (have a Manfrotto Triminar). So can you use the fluid head for general photography? I would guess going vertical is the problem with it. I was planning to get one of the Manfrotto ball heads and put a rig on that.

Then of course there is the external LCD screen to get as well. The ME-1 is nice too, as the Rode requires a 9V battery.
Just to give people an idea of what the D800 is capable of becoming a part of, here's a great image of one in action during a production:
And the kind of rig I would like...something compact...

Here is Lanparte's full rig on the left and a variation on the right:

Here's a D800 with just external LCD screen and LED light source (edit: note the variable ND filter on the D800 lens...this is to be able to keep the shutter speed low)...
Then there are topics like primes lenses for Nikon (best example being the Zeiss primes), etc..