Colour negative film is not normally used used for reproduction work as most organisations prefer transparancies. When choosing a film you need to pick the right film for the intended photo.
The positive uses of film are:- Better Dynamic range - In Black and White. Allows for minor focusing issues along with minor exposure issues and film has a higher resolution than digital.
I went out on a Friday evening with and old Minolta AF25 point and shoot loaded with AGFA Vista Plus 200 and took the following photos.
Sources - Wikipedia and 35mm handbook