Destruction regimes of Sun-skimming and Sun-plunging comets