I was terrified too. Here's my experiences:
DS1 was a horrendous birth because he got stuck. I had an epidural which can up the risk of the baby getting stuck and sadly I fell on the side of the stats where he did. He ended up a forceps delivery, I suffered a 3rd (nearly 4th) degree tear. Awful awful recovery.
I somehow worked up the courage to have a second. I was adamant that was not happening to me again but the thought of C section recovery was also daunting with a toddler in tow. With the agreement of my consultant I booked a due date C section with instructions that if the baby came beforehand I'd have a low threshold for intervention and emergency C section. DS2 came 3 days early and quickly. There was no time for any pain relief other than gas and air and he was out. Minimal injury (minor tear) and recovery was amazing, I was out of hospital a few hours later. I dropped DS1 at nursery in the morning, gave birth to his brother and could have picked him up again at the end of the day (but I decided I'd give myself the nursey pick up off that day haha)
Two completely different stories of birth there and I'd have never believed I could have had the second story based off of my first one. You never know what is going to happen until you get there.
I do suggest having a think now about the types of thing you would and wouldn't want if you were thinking of a vaginal birth. Pain relief you'd want, intervention if things aren't going smoothly. It is overwhelming when you get there, and you're a little bit preoccupied when you arrive so aren't in the best frame of mind to be making decisions. Whoever will be joining you in the room, make sure they are also informed of what you'd prefer as there were points where I just didn't want to talk anymore and my husband took over because he knew what I wanted.
Whatever you choose, all that matters is that you and your little one are safe and sound at the end of it all. Those first cuddles make it all worth it!