I have done many service change out, and the biggest reason why most homeowners consider a service change out is they think upgrading from a 60 amp 4 fuse house to a 100/200 amp breaker panel without adding circuits will solve all the blowing of the 30 amp fuses they have been putting in to over come all the new kitchen appliances we now have, as you see this can be an up sale right off the Bat when looking at a service upgrade, the other thing I watch for is double fed circuits from the same phase, I do this by turning off all the circuits and only turning on one at a time then check all the off circuits to see if they come alive, another thing is to watch out for 240 volt circuits being fed from two different fuses/breakers, I take photos of every panel before I remove any wires, 37 years at this has made me quite aware of the nasties that can come about after an upgrade, so by looking for DYS work, and other things can let me sleep at night.
The most common mistake for electrican doing an upgrade?
landing 2 wire romex ran for a 240 volt load and feeding it with 120 volts, good way to burn up a well pump or AC unit.