A mutation that changes a single base can change the amino acid that the codon codes for, which can have knock-on effects on the protein structure and function
Most mutations don't have a significant effect, either because they only slightly affect the protein or because they occur in non-coding DNA that doesn't code for proteins
Insertion and deletion mutations are worse than substitution mutations because they shift the subsequent codons, completely changing the amino acid sequence