But why ask about "the hardest day in your life" instead eg "the hardest day at work"?

Personally asking this kind of personal questions sounds very weird. You can evaluate soft skills and culture fit by asking more relevant, professional questions. Except if the reason to ask this kind of more personal questions was sth else.

The cynic in me says because they want to select candidates whose work IS their life.