With any piercing, you'll have people who say it was the worst pain ever and others who say it was nothing. I've especially noticed that with tragus piercings, the reviews are very mixed. The best thing to do is just go for it and see for yourself... a good piercer will be able to do it quickly and the pain won't last for more than a second no matter how bad it is! That's what I always tell myself with piercings.
I have 1/2" lobes and 11 piercings: left helix x2, both conches, both nostrils, septum, navel, and VCH.
My lobes are small but I know a lot about stretching and how to do it safely, so message me if you have any questions!