There are many different fonts available.
The typography used in your film can greatly set the scene, attract a certain type of audience or tell you more about the characters involved...
The film Pearl Harbour uses a classic font called Palatino... This suggests the film is not set in present day as it has and old feel to it. This also gives it a classic feel, and implies the class background of the characters.
The film Rocky which is about a tough boxer uses the font Franklin Gothic Heavy, which is a Sans serif font, the font is block and bold which adds to the appearance of Rocky's masculinity in the film.