I was nervous too but once you're in the throes of it, you'll most likely be so focused on managing it that your fears will subside.
I enjoyed mine. It wasn't painless but it was bearable because it wasnt constant. Even though they were strong contractions, I had time to rest inbetween.
Then they gave me some wonderful drugs -that injection in your leg? And gas and air? And it was like floating on a cloud. Really really bad period pain, then cloud, really really bad period pain, then back on my cloud.
The only time I felt like I couldn't do anymore was when I was near the end. Very common phenomena. Once midwives hear that they know baby is imminent. 10cm. Waters broke spectacularly, all over midwives.
Then the most indescribable urgent need to push. They told me to stop at one point but it was so hard not to - try to listen to them with that, it's to save stitches as much as possible. 2 pushes and he was out.
6 hour labour.
And then the most wonderful moment - I had my little boy on my chest and he was the most beautiful, amazing thing I have ever seen. And all that pain and effort immediately disappeared. Fucking magical.
I asked for them to wait to clamp the cord. And I gave birth to placenta naturally (no injection for me).
Not every birth story is like this. It didnt go to my birth plan (they rarely do) but I still loved it. And I want to do it again!
The key is to try and remember it might not go to plan so go with the flow as much as possible. Don't fear the pain if you can. Find your coping strategy and you'll be fine. Gravity helps too... apparently kneeling is a great way to give birth - I'm going to try it next time I hope.