Ira Levin's
A Kiss Before Dying has some great twists. The movie versions tried, but there was no way to, uhm, screw with your mind in the way the book did. You'll know what I mean when you read it.
I read it because Dean Koontz mentioned the twist in one of his books on writing, and he made me curious. It's also unusual in that the major twist comes about one-third of the way through the book rather than at the end. Unfortunately I can't find an e-book version.
Years ago, I read a serial killer novel called The Ultimate Game that had a major twist at the end. However, while the overall effect of the twist was really neat, I came away frustrated. There are twists that make readers gasp, and there are twists that make them say "Oh come on." Your mileage may vary, of course.