It varies on person (including mental state), needle size, and nurse/operator skill. I suspect one bad experience with a needle can prime someone for a poor response in follow up experiences.
Indeed. Both covid jabs were perfectly fine, it probably doesn't get any more painless than that come to think of it, but I had a regular one in February with a cocktail of various vaccines and that one was much less pleasant.