It depends on what files you are comparing. Hi-res provides more information from the original recording but if the information wasn’t there in the first place…
That often happens with files touted as hi-res but which are no more than resampled versions of lower resolution original recordings. Provenance is everything - not that the record labels give you much to go on. Further IMO some music genres are not that likely to contain additional information that is easy ( or possible) to discern - death metal anyone?
Finally we are talking about refinement. If you are listening for more bass or additional instruments or when the drummer drops a stick or the conductor’s podium creaks then that is not what hi-res is about.
I would agree that all of the dCS lines will provide renditions of redbook that is subjectively better than lesser equipment can manage with SACD or other hi-res formats . But that is not to say that genuine higher resolution recordings will not reveal their benefits.
My advice is not to consciously compare in the sense of looking for some magic moment. Just let the two versions of a genuine hi-res v. redbook file play and decide which you feel happiest with. Then replay the other one .