When considering the "best", one must consider the weakest link in the chain.
For instance, I bought some super cheap lenses K mount lenses of local CL. So cheap it came in plastic grocery bags. For so cheap - condition unknown, I couldn't believe the results I was getting from the Pentax M 50mm f4 macro lens was so sharp I got curious and tested it using Kodak Techpan at ISO25 processed in Kodak Technidol. I then scanned results using my Coolscan 4000dpi as well as 36MP Nikon D800 and got the results below.
Resolution testing my SMC Pentax-M 50mm F4 macro lens by
Les DMess, on Flickr
The 1:1 crops on the left show the results from each method and the large 1:1 crop on the right is about a 4.5X optical enlargement of the center area and clearly shows the information captured on the 35mm frame of film that cannot be fully resolved by the various methods I used.
I don't know what you mean when you state, "especially if shooting film" but obviously the results you get on film will depend on the film as well as the subject, tripod, lighting, speed and lens used. At this point I know scanning this film is a major limitation and not the film nor the lens. I am not even sure if the lens, film, setup or target is the weak link.
I have a few 50mm M42's. I have taken many pics with each and these are all very good performers. Even that 55mm f2.2 preset that came with my original AP.
M42 50s by
Les DMess, on Flickr