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's shape and function
Most mutations don't have a significant effect, either because they only affect the protein slightly or because they occur in non-coding DNA that doesn't code for proteins
Insertion and deletion mutations are worse than substitutions because they shift all the subsequent codons, completely changing the amino acid sequence