cif, sorry you didn't like 'Smoke' but for me it pushes all the right buttons in a very personal way. Plus the last 10 minutes with Tom Waits singing 'Innocent When You Dream'....
Both "What Dreams May Come" feat. Robin Williams & Annabella Sciorra and surprisingly "Drop Dead Fred" had me weeping at the end. I'm sure others won't agree, but I found both films very moving, and exercised the tear ducts adequately.