Jordan's fingertips clung to the cliff edge. He knew he'd never survive the 1000-foot fall if he let go, and yet his fingers burned with agony. This must be the end . . .
A protagonist in immediate peril--who could ask for more? Well, me, for one. I don't know who Jordan is, so I really don't care that much about whether he falls off the cliff. In fact, I'm not at this point very much concerned about his burning fingers. Other than the fact that this story has "action" I have no clues about plot or genre. I'm left with the impression that the author is trying to sell me a story rather than tell me a story.
A second example of an over-hook is simile overkill. I think authors should be weary of similes in general, but a whopper in the first sentence or two smacks of an over-hook. For example, Bob's head pounded. If felt like a thousand scorpions were tap dancing on his frontal lobe.
An author creative and clever enough to come up with a unique simile--who could ask for more? Me, for one. Sometimes a simile can be an effective tool, but, in this instance, if feel like the author is screaming "LOOK AT ME!" I'm not looking for a clever author, I'm looking for a stunning story. If I get to the end of the story having ben lost in the author's world for a time, then I realize the true talent of the writer.