Your post prompted me to look in Lightroom. I hadn't realized that there wasn't a camera specific profile for the M6II. I have always preferred the other profiles that Adobe supplies, so I've never noticed the lack (I never used the camera specific profiles on my other cameras for which Adobe supplied such profiles). There are something like 52 different profiles provided as standard. I really like the Adobe Color profile as my starting point, but I suppose if you really want to mimic the look of the Canon OOC JPEG exactly, you want a camera specific profile. Just out of interest, what is it you don't like in all the different profiles that are provided?
I am in the process of trying out the M6II and the RP. I came from Fuji where they have really nice camera profiles and since I do mostly Landscapes I used to use there Velvia profile.
So, I wanted to try out Canon's Landscape profile. From the Canon site :
The “Landscape” Picture Style changes the color respectively; blue to a vivid and deep color, green to a vivid and bright color.
Anyway, with the RP, when i applied the Landscape profile to a test raw, it did just that. It was superior to both the Adobe Color and Adobe Landscape profiles. Another question I have, I know the Landscape picture style modifies sharpness, do the Lightroom Profiles do the same thing? Or does it only affect the color?