This isn't a movie but....I got the box set of the series The Prisoner (from back in the 60's). There are only about 15 episodes and I had never seen the final episode. What happened was so unexpected that it blew my mind. The more I thought it later it didn't make sense but still a totally unexpected outcome.
"No Way Out" has a pretty good twist... Even if it's a Costner film...
Dirty Mary, Crazy Larry.
Primal Fear with Richard Geer and Edward Norton
To Live and Die in LA , did not see that one coming -
One of my all-time favorites....definitely expresses that quirky underbelly possessed by the City Of Angels....
(the Wang Chung soundtrack ain`t bad either....)
It took them what seemed like forever to bring this out on DVD....