Under idea conditions such as camera on a tripod, mirror locked up, high resolution film and a static subject I'm sure there is a difference to be seen between a Leica lens and Canon, Nikon, Pentax etc.
I agree with Film-Niko above: In the last years the brand of the lens has become much less important, as today even lens manufacturers like Sigma and Tamron have certain lenses in their programmes, of which Leica and Zeiss would have been proud of having in their programmes 20 years ago.
So the decisive factor is indeed having a modern lens design which matches perfectly today's advanced highest standards versus having an old lens design from the 60ies, 70ies or 80ies.
And from my tests - and those of very experienced photographer friends and professional test institutions - I have to say the difference of most of these modern high-performance lenses compared to the older designs is really very significant and very clearly visible.
And very clearly visible not only under ideal conditions with a camera on a tripod, MLU, high resolution film etc., but also very clearly visible in normal, standard all-day handheld photography with all kind of films.
I can often see that difference already when looking at my transparencies on the light table even without (!!) using a loupe. Especially when I compare the results of my latest Zeiss lenses compared to my Nikkors which were designed in the 70ies.
Two different worlds in optical and mechanical performance. And the reason why my older Nikkors are rareley used anymore, being de-facto 'retired'.
However, under less than perfect conditions, such as in a jazz club using Delta 3200 handheld at 1/30 s I doubt there would be any discernible difference on the negatives between a Leica and others.
In such situations I am always using my best modern lenses, because I really benefit from them: In my local Jazz club there is a certain distance to the stage, so a 85mm lens works mostly best.
My Zeiss Milvus Planar 1.4/85 offers me in that situation the following advantages compared to the older Nikkors like the 2.5/105, 1.8/85, 2/85, 1.4/85:
- much, much better performance (sharpness, resolution, contrast, 3D-rendering) at open aperture, and at 1 and 2 stops stopped down
- as you have a quite dim light, the possibility to use f1.4 with excellent sharpness and contrast is a real win, and allows using shorter shutter speeds as well
- another very important advantage: much, much better flare resistance of the modern Zeiss compared to the older Nikkors; with the strong spot-ligths on the stage flare can be a problem in such situations, and the Zeiss performs much better in that regard.
The Zeiss Milvus Planar 1.4/85 belongs to the best lenses ever built. It is a "Baby-Otus", as you get 95% of the Otus 1.4/85 performance, but at only 1/3 of the Otus price

.
When I bought that lens I started comparison tests to all my other 85mm and 105 lenses, and the Milvus surpassed all of them.
I think everyone here knows Steve McCurry's most famous photo "Afghan Girl". That was shot with the also famous Nikkor 2.5/105. Those who have that Nikkor know it is really a very good lens, especially in the f4 to f8 range.
The 2.5/105 Nikkor has been my first portrait lens as a young student. I worked hard for it (significant amount of money for a poor student), and was very proud of then having and using it.
In one of my comparison tests I put both lenses on my Pixelschubse

and started pixel peeping by zooming in to 100%: The Zeiss was already at f1.4 as sharp as the Nikkor at f4........three stops advantage, really amazing!
Means in practical daily photography that I can much more often use a slower, much higher quality film. The difference of Delta 100 vs. Delta 400, FP4+ vs. HP5+ or TMX vs. TMY-2 is very significant.
Best regards,
Henning