Christopher Campbell lists his 10 best movie titles of the last 10 years. There Will Be Blood, All About My Mother, and The Perfect Storm (as one that has entered the American vernacular) are good choices.
I'll draw up a 10 list, as soon as I think of one.
The best title of all time could well be Things to Do in Denver When You're Dead. Has anyone actually seen the movie? Yet everyone knows the title.