I just made a thread (my first here, long time reader, first time thread starter) about the 35 1.4L VCM which requires heavy lens profile correction. If you want to read that (and see an accompanying video, which I can't directly link to until 24 hours has passed but if you just put "watch?v=JzkSuG226V4" after yt dot com you can watch it before the forum robot allows me to post the full link tomorrow) please feel free, but the TL;DR is this: I too was scared off by all the lens profile criticism, but I ended up buying it thinking I'd get a kick booty video lens for my R5mk2 and a hobbled photo lens. Owning an RF 50 1.2L and the 24-70 2.8L IS USM I didn't mind, as I could always rely on those for great stills.
To my shock the 35 1.4L VCM is sharper and has better contrast (slightly better in the middle, significantly better in the corners) even when viewing the uncorrected RAW files. The correction is mostly fixing the barrel distortion and vignetting, but both improvements are visible pre-correction.
So to me, that eliminated my fear of lens profile correction given how great the corrected RAW files look. In fact, I'm now contemplating trading in my 24-70 2.8L and getting the 24 1.4 VCM, assuming it performs similarly at its focal length to the 35 1.4 VCM. Though I'll miss the ease of zooming of the 24-70, I'll have 24, 35 and 50 covered via the 1.4 VCMs and the 1.2, and have awesome video capability at 24mm and 35mm, as well as unlocking f/1.4-f/2.5 at those two focal lengths. The MTF chart does look better for the 24mm than the 35mm so I'm optimistic!