Formulate an answer to this elaborate question: After appearing in the Stephen King adaptation Misery, Richard Farnsworth received an Academy Award nomination for his part in which 1999 film?
The Straight Story