My experience with the Pfizer vaccine was exactly the same as bluesman7 describes.
My wife got the 2-shot Moderna vaccine routine, with nothing more than a sore injection site.
My brother got the J&J one-shot, and only had minor arm soreness for a couple of days.