Many thanks for the analyses! You had collected a lot of data. It is worthwhile to look at them again as a whole. :-)
I want to elaborate on @Kdo's comment, because the analysis has not considered (nor mentioned) another aspect: power scaling, i.e., an increased power consumption by X% does not lead to the same performance increase of X%, see
techspot.com/review/2262-intel-core-i7-11800h and
youtube.com/.... The lower the power consumption, the better the energy efficiency (typical for a processor).
Why is this relevant to your analysis? Although they are all "45W" CPUs, the Intel CPUs generally run at much higher wattages (see your 'Power Consumption Cinebench R15' interactive graph). So your analysis has a bias for AMD, and against Intel. Accordingly, a fairer analysis would be to compare CPUs for specific wattages (or wattage ranges); see links above.
I did this over the last year using your data for the i7-11800H and R7-5800H, since you generally report the PL1 (Sustained) wattage numbers (but not always correctly; sometimes I had to readjust them using the screenshots in the individual tests if the power consumption is apparent, otherwise I ignored the test as a data point). Accordingly, I arrive at these values (as of Nov. 2021, average values based on the averages from your Cinebench R15 Multi endurance tests, i.e. not the maxima of the often first run):
Watt-range (+/-5) i7-11800H R7-5800H Energy efficiency (R7 vs. i7)351405193838%451675208925%551790200412%651855no data-75195221239%85206220520%
What does that mean? The R7-5800H is only over 30% more energy efficient than the i7 as long as both run at less than 45W. With increasing wattage, the R7's advantage gradually dwindles. This is also confirmed in the analyses shown in the links above (i.e., the power scaling of the R7 is worse than that of the i7, at least above 50W).