Hi 👋🏻
I've had both and to slight extremes, so feel qualified to comment.
My first was a fairly uncomplicated natural birth until the end - just hypnobirthing and gas and air. It was a fairly long 48hr labour and 2hrs of pushing, however. She managed to get her arms up and got a little stuck, which lead to me having a complicated internal 3rd degree tear. So after the birth I was rushed off to surgery, which took 1hr and involved having a spinal, missing the first hour or 2 with my baby, being initially fairly immobile and a 2 night stay in hospital. I'll be honest I hated the stay in hospital (covid times) and wish I could have just gone home. I felt pretty sore/bruised after it all and was a bit of a shock to the system. However I've been fine "down there" since it healed and all is good.
Because of the tear I opted for an elective c section for my 2nd to avoid any further damage. Although the section was daunting, the whole experience was fairly unstressful. The only thing is that I get the shakes with the spinal, so I shook all the way through the section (the same thing happened during the tear repair surgery after my first), which makes the whole thing pretty uncomfortable. I ended up staying only 1 night and, although the recovery was longer and initially tricky, I felt much better physically and mentally to look after the baby than I did after my first. Maybe some of it is because I knew exactly what was going to happen. Maybe it's because I didn't go into it not having slept for 2 days. Maybe it's because I only had surgery rather than a 48hr labour, pushing a baby out and THEN surgery on top.
If I hadn't had the tear I would have gone through with the vaginal birth again. It was not so horrendous that I wouldn't do it again. Don't get me wrong, it was painful as you expect, but it was absolutely manageable with the right help or preparation. It was everything else that happened after that affected me (the tear, surgery, stay in hospital). I was unlucky with the tear with her shoving her arms up 😅 up until then i had a classic labour and my pushes were so strong - my body was just doing it!
I don't regret my decisions either time - they were right for me.
I guess the only thing with the section that would sway it for me if I was so terrified is that there is only one point in the section that absolutely requires your co-operation - when they put the spinal in. Other than that you're fairly passive and it is all done, you can try to distract yourself if you like. However, vaginal birth does require a certain amount of active cooperation to get that baby out! If you can't get your mind into a good place for that then it may impact how it goes.