OK, I expected Sixth sense to be up there, but I thought Infernal Affairs' plot twist was very good and interesting. OK.. if we can't include asian movies, then.. The Departed ?? (I haven't seen it but it's pretty much the same, no?)

Other movies with good twists according to me:
Memento
The Others
Shawshank Redemption
Vanilla Sky