It's always difficult to judge from an image or video as the camera is rarely able to show the true colour rendition, plus difference in your viewing screens etc. For example on my monitor, I'd say you'll see reds that are a lot more punchy than they seem to be in that video (obviously dependent on settings).
In terms of settings, I've not tested the Vivid II long term, just an hour or so playing around (the Vivid II's I bought are for a future tank I will be setting up towards the end of the year), so will let others comment on that. Certainly on my WRGB II which I have tested longer term, I find the greens a little too over-pumped if left at the same level as the red and blue, so I tend to set the green channel 10% lower than the other two.
There are lots of controls that will allow you to tailor the colour to your preference. You can either change each channel independently, or use the colour temperature slider to change the colour automatically. There are also a number of presets to choose from to give you a starting position to tweak from. I used those initially and found I preferred the 'Buce' setting the most, then I just upped the red a bit to preference, and found I liked red and blue at a similar level, and green reduced a bit. I'm sure other folks prefer settings that are completely different though - there is no wrong answer, its all down to personal preference - so thank goodness we're not stuck with one colour output 😉