I think two of the sound elements are the most important - engine (exhaust), and tire.
The former gives the sense of power and speed, while the latter gives much more, including all situations of contacts between car and ground. These two are the most important aspects of how a car is driven.
I remember back in GT5, there's massive tranny winning whenever the fully adjustable racing unit is in the car, be it OE in those race cars or modded road cars. Some road cars (especially older muscle cars) need this mod, but the straight cut gear box is just so noisy that it's enough to kill the nice V8 notes, and almost dominate the whole auditory senses. That sucks. I quit driving those cars because of that annoying noise. Is it realistic? Maybe. Is it good for my driving? No! Is it enjoyable? Absolutely not!
In GT6, noise of straight cut gears is still there but with a better proportion. As to other elements, I think they are about right, if not perfect. (The largely hated tire noises, I feel it rather helpful for my driving. OTOH, I really hope there'd be proper wind noise! )
IRL, in a car we are familiar with, we tend to ignore the noises which are not useful, be it squeaks of interior, or clunks from the messy trunk. For many of such minor imperfections, they're not affecting the performance and safety so we're not going to fix them immediately anyway. So we ignore them.
In a driving simulator game, do we really need those minor noises which we'd probably ignore when doing hard driving? We don't, actually. If some more details can be properly presented for a more complete experience, yes they are welcome. But if not done right, I'd rather keep it simple. More doesn't always better. (especially the hardware resource is running out)
About the two films in the OP, TBH I don't like their sounds. No experience on any real race car, so I can't tell if it's realistic. But anyway, to me, they sound unsmooth, badly lubricated, instead of what a powerful fast machine should be. And, are all those crackings helpful, usable, or enjoyable to me - the simulator driver? I'm afraid not. Sorry.