It depends what kind of image you want. If you find a really colorful scene, some nice relatively unsaturated films like provia or kodachrome will bring out very subtle tones. Velvia would take that same scene and make it look ridiculously colorful. Either way the important thing is finding the scene and composing. Film choice is not going to make or break a photograph.