Shallow Grave - saw it at the pictures, and actually said "Yes!" out loud, and louder than I meant to, which got some funny looks from people sitting near me!
I don't know about 'best' as in uplifting or entertaining - but the ending of The Boy in the Striped Pyjamas (if you hadn't read the book) was very shocking and thought provoking.