Everyone is going to experience pain differently, and I truly believe that your state of mind heavily influences your experience. If you go into labour with fear and the expectation that labour will be incredibly painful, then you're probably going to experience it that way. Pop culture portrays labour and birth as THE most painful experience of a woman's life, so it's no surprise that so many people are afraid of it.
I spent some time prior to my birth rewiring my expectations of labour and birth. I started thinking of it as natural and not necessarily painful; any pain you experience from labour itself is for a purpose, it doesn't mean something is wrong with your body like if you broke your leg. I also practised a bit of hypnobirthing beforehand for the relaxation.
I had a completely unmedicated birth 3 weeks ago and it honestly wasn't very painful to me (and I was in labour for 56 hours). Staying calm and not screaming helped; there were times I could have given in to the sensations and I KNEW it would make them worse, but being calm and breathing through them helped tremendously! I don't know what transition is, but I don't think I experienced it. I also didn't feel a 'ring of fire' or anything like that, and pushing wasn't painful at all, just exhausting. I didn't tear at all so I was back on my feet right away.
Besides being calm, breathing, and not expecting terrible pain, the other things that helped were being able to change my position whenever I wanted and labouring in a comfortable place for me (at home). At least for me, setting made a huge amount of difference, and I bet I would have experienced pain differently in a hospital since I'm not comfortable in hospitals. (If you are, then it probably won't affect you.)
Best of luck -- you can totally do it!
