My favourite critical failure was with Avatar-Shadowheart. She has a DC of 0 to recognise the Nightfall Feast in the Grymforge and rolled a 1, resulting in Gale having to explain her religion to her.