Of course, of course Usual Suspects has one of the best endings ever and Se7en is brilliant. But, let's think about the great emotional endings....Monsters Inc, anyone?
Now, before you scoff, just think about the ending. Sully coming through the door into Boo's room. This is the little girl that touched his heart a long time ago, and he's about to see her again. You're thinking what he's thinking - will she have grown? Will she recognise him? Will he recognise her?
The ending shows nothing of the actual meeting. Instead, you hear Boo cry out 'Kitty' and a big smile comes across Sully's face. Fade to black. Pure brilliance....