Is a small percent error always indicative of a successful experiment?

Not necessarily. A small percent error only means the experimental value is close to the accepted value. It doesn't guarantee the experiment was conducted correctly or that all sources of error were accounted for. Precision (small error) doesn't equal accuracy (correctness).