Hi - I do suggest having a look with DxO Photolab Deep Prime - it does really help with these Canon sensors at the ISO 800-6400 level. That not the subscription was main reason for me leaving Lightroom (as in most other respects I much preferred it).I’m pretty much right there with you when it comes to my own results. The output I get at 1600 is a bit hit and miss in terms of noise at 1600. Some look pretty decent to me and some are too noisy even when I’m careful not to underexpose. At 3200 I’m rarely pleased with the results in terms of noise and overall I don’t think I’ve had a shot at 6400 that I was really happy with in terms of noise. This was also pretty much the case for me with my 7d mk2 so I’m not really disappointed with the R7 as it seems to perform as expected and I just do my best to work in the range where I’m happy with the output. High ISO noise performance isn’t in my opinion one of this camera’s strong points but I think that can generally be said about pretty much any crop sensor camera.I have come from an A7C to the R7. I understood the compromises and the benefits, particularly in telephoto lenses size and overall weight.
However...
In my experience, I am struggling with the ISO performance a bit. I feel quite intolerant of most samples at 3200, and even some at 1600. I struggle to find anything at 6400 that I'm pleased with. I hear what everyone is saying with LR, maybe that will make a difference, but I fear it won't make a big enough difference. The A7C was easily a 6400 sensor, and 12800 was recoverable with a bit of work. With the R7 I feel like my threshold is somewhere between 1600 and 3200 is tolerable, 3200-6400 is a struggle.
It is a bit of a double whammy with the 100-400 being f8 at the long end, and the 600/800 being f11. Again, I knew the trade offs going into this, being able to fit the 18-150 and the 100-400 in a tiny Peak Design sling is fantastic, there was no chance of doing that with the Sony 200-600.
IMHO it does not still make ISO 25600+ any good though but YYMV.