Do most mutations have a significant effect?

No - most are silent mutations and do not affect the resulting protein. (because the code is degenerate, multiple codons code for the same Amino Acid)