You are discussing about scanning the slide film.
It is completely different than projection.
Scanning actually benefits from the DMAX loss with consumer-grade scanners because of CCD noise in high density areas.
OTOH, deep blacks is a MUST for a good projection experience when projecting dark night scenes (those often shot when high EI is most needed!)
You can get any color balance with any film type you want. With neg film, you have more freedom in darkroom. With slide film, you have to use filters on the lens when shooting.
In the example above, the photographer has decided to go with very different color balances, which is nice because the same image gets boring if nothing changes. It is not a film comparison. It is not a neg vs. slide film comparison. It does not compare color balances. That same 800Z can have almost any color balance you like.
Neg film and slide film have completely different purposes. Slide film is mostly for projection and neg film for printing. Both can be used for projection and printing but are quite different beasts, each having their own benefits and drawbacks.
I can say from experience that you CAN print that Fuji 800Z image as magentaish as the Provia picture -- but you CAN NOT print that Provia picture as greenish or neutral as the 800Z picture, at least not very easily.