Great article. My favourite he's-actually-insane twist was in a certain silent German film from 1920 that I won't name in case you've not seen it.

I wrote this piece on twist endings, if you're interested.