Phenomenon (1996)

John Travolta sees a flash of light in the sky and then starts being able to move shit with his mind. At first everybody thinks he was visited by aliens that gave him superpowers, but then it turns out he just has an enormous brain tumor, and he dies (seriously).* [NOTE: I remember that a good friend insisted, years ago, that this movie is really, really good; on what authority can I possibly say he's wrong?]

In which a man suddenly gains the power to open books.

* SPOILER ALERT: This is also how Green Lantern (2011) ends.