I think the film MOMENTO would fit here. That one confused the hell out of me. I haven't watched it a second time because I feel like if I did it would be kind of anti-climatic, but it's definately one that needs to be viewed twice just the same.