I usually respond with "Bless your heart" or "Ain't it awful?" or some variation in my best deadpan. That way they get the sympathy they were looking for and I get to privately indulge in schadenfreude at their 'misfortune' and we both go away happy.