I have had both Pfizer shots and my wife had both Moderna shots. In both cases the second shot was worse than the first - but not all that bad even at that. I had a harder time with the second shot than she did.
I would do it again in a heartbeat if I thought it was needed again.