All engines run out of "puff" as the revs rise. Some will continue to produce or record "power" in BHP to the redline however the ones that do will most definitely have their torque declining by then.
If you look at a 197/200, peak torque is what, 5500RPM or thereabouts? At what, 140 lbFt or something like that? It then tails off to around 100 lbFt or maybe less by around 7400RPM, but, at this point the engine will be making peak BHP due to how BHP is calculated from revs and torque. By comparison, a turbo engine will generally not rev as high as an NA engine and it's powerband will be a lot sooner or lower in the revs, like on the VXR it peaks at just past 2000RPM (180 lbFt-ish) and should hold near enough flat to around 5500RPM where it'll then drop off steadily before the limiter at around 7000RPM. The graph you put up of the VXR had massively different scales for torque and horsepower and so the decline in torque looked drastic when in fact it's the scale of the graph that's exaggerated it, believe me.
On a graph, you look at the area under the line. The more you have under the line, the more poke the car has at any given point. That's a way I was told to understand them and it's very simple. For example, compare a 197 and VXR rolling road graph (using the same scale increments) at say 3000RPM and the VXR will have a lot more "under the line" than the 197 will. So if you were in the cars and in the same gear (or as close as you could be the same ratios at least) and both at 3000RPM and put your foot down then the VXR would pull away. I hope that makes sense, if you look past the first graph on Google and see one with decent scales for a VXR and the same for a Clio then you'll see exactly what I mean then and what others have been trying to explain too.
Example of how a graph with decent scale should look for a VXR...
Also, be mindful of graphs that mix metric and imperial figures. The one you posted has the torque in NM (metric) and the power in BHP (imperial). That skews things, it should either be NM with KW or PS or lbFt with BHP, our brains aren't set up to mix metric and imperial easily. We're generally taught one or the other at school and only learn basic conversions like mm to inches, we use imperial here where as the continentals prefer metric.
It's early and my brain hurts but I hope that helps. (y)