Back in my military police days, we got smallpox shots about 2 weeks before we took classes on hand-to-hand combat. It hurt like a b--. They changed the schedule after numerous complaints . . .
Aside from that, I can't recall any shots that ever hurt.