I mean, basically, if it's just, "I'm sorry to hear about your mother" at the funeral, I'm fine with "Thank you."

If it's, "Why didn't you get back in touch with her?! It was killing her!" then yeah, I'm good with saying whatever seems most specific and relevant to the actual question. Because get a grip, people.