the best thing about labor pains is that it's only temporary, and they do have meds to help with that, and during the pushing stage, your adrenaline is so high and it goes by so quick that you don't have time to worry about or focus on the pain. My first birth experience with DD was rough, but I was in a crap hospital, so that's to be expected, my birth experience with DS was amazing, despite being in unmedicated labor for over 36 hours, I pushed at my own pace, rested when I needed to, and my midwife I had for DS had helped keep me from tearing, so recovery was really quick and practically painless. From experience, I can definitely say that the birth of your child will be the most amazing, and quickest day of your life. Seriously, from start to finish, it goes by in the blink of an eye that you barely remember the pain.
I think the health providers, the support you have, and the environment you give birth in makes a huge difference between a good experience and a bad one, so if you are worried about it, do plenty of online research before getting pregnant and look for hospitals with low C section rates, low intervention rates, or OB/Midwives with very good reviews from their patients.
The best thing you can do, with everything concerning pregnancy, is try and stay calm, stress and worry only makes things worse, and if you have questions for your provider, ask away, anything and everything you can think of, even if you think it might be silly, just ask, as long as it will help ease your worry.