Can someone explain the cost difference between letting a transaction fail vs cancelling it

Just saw this in jungle freaks where the mods in the nft drop said cancel your transaction and everyone freaked out saying they should of left it pending or let it fail for gas fees. Can someone explain why cancelling is such a negative