I loved the 30mp on the EOS R! A MP count of 30ish is my personal sweet spot to be honest. It leaves plenty of room for cropping and still all devices can handle the data very well. I know, technically you can't spot the difference between 24mp and 30mp, but for cropping it is good to have a breather. Also, shooting in crop mode with 30 MP or cropping a vertical pic out of an horizontal image still gives you double digits MP count. The EOS R had 11.6 MP in crop mode. I absolutely loved it!
The 45 MP of the R5 are too much for some use cases, e.g. I often take pics in school (I am a teacher) at events and putting several pics in our cloud does slow down the process a looooooot. Also, airdropping the pics of the students on to their iPads sometimes proves to be difficult with big file sizes...At the moment, I often intentionally shoot in crop mode e.g. the 24-105mm F4 is incredibly versatile as an approximately 40-170mm (exactly 38,4 - 168mm) lens. It also keeps the file sizes down.
I might solve this problem by getting a second camera with 24 mp (I see you Canon R8) so I have the best of two worlds.
A R6mkiii with 30mp (stacked or non-stacked... I don't care) could be a perfect comprise for me. I´d have sell my R5 to do so... and wait for rebates/ cash back... I don´t know. Just a thought. If the body is a bit smaller and especially lighter, I might switch.