This figure of speech comes from the personal habit of biting one’s nails if a person is nervous or experiencing a lot of stress, worry, or concern. If something was a real nail biter, it was suspenseful with the outcome in doubt. The person speaking the phrase usually would have some emotional investment in the book, movie, or game.