I agree, Vivid setting is too much. Red on the D70s was even worse.
With D200, no matter how good I think it is on the LCD, it still comes out seemingly underexposed when downloaded (which is just fine for me). BTW, in my work, I need to shoot in dark dimlit rooms where metering sometimes show 15" to 30" shutter speed, no luxury of tripods, no time to set up CLS flashes, just one flash, 15 to 20 minutes to take 30 - 40 shots. On a calibrated monitor screen, this is where Nikon Capture 4 comes in, a lifesaver, it just works brilliantly to make the photo clear up and have very high resolution. This is through a combination of the wonderful D-Lighting feature, Curves, and Exp. Comp (really important and I find it way accurate over that in PS CS2), and a few more.
Other touches is to balance contrast and brightness using Nik Color Efex Pro 2.0 software. The Brilliance filter of Color Efex is fantastic in improving vividness, without saturating color. This is what I would call real Vivid function, indispensable filter. Will wait for Nik's compatible Color Efex version for Capture CX before moving on to CX
I only use PS now to "Save To Web" ...
This is just me of course, I find post processing an essential, inescapable task, whether in automated batches or manual, and I prefer vivid but not saturated shots depending on the subject.