I've not really entered this debate, but thought I'd add my own experience.
The wonderful thing about childbirth is the way the endorphins "change" the memory. You might be screaming at one point, but once the baby arrives, it all fades away. I spent the whole of the day after ds was born trying to remember why I had delayed having the diamorphine - I knew there was a reason, but my memory was already blurring. (The reason was because I knew there was a possibility that I would have to be induced if I didn't progress fast enough, as my waters had broken the day before).
My recollection is that I had a positive experience of childbirth - yet others might not consider it to be, as it ended up being forceps, episiotomy, tear and stitches. I had gas and air and diamorphine - and a relaxing tape that I insisted was on all the time. Apparently I got quite distressed every time it finished, and dh had to play the (shorter) CD version of it while it rewound. For me, that is my main memory of the (long) labour - plus the joy when ds was delivered.
I never screamed that much (so dh tells me) - in the end I needed the forceps because I was so tired that I was starting to sleep through the contractions (!!) and ds was turned to the side and not descending.
I did have a "fear" of an epidural - and when they offered me one prior to the forceps, I turned it down on the basis that I didn't want the "risk" (in my head) of one, plus it was take too long to get organised anyway (and I was soooooo tired) and that although they told me that the alternative of a puddendal block might not work, that the pain of the forceps would be over and done with really quickly.
In the event, the block worked - and interestingly, my dh, who had been really concerned with how he would cope with seeing me in pain, (and had got quite distressed while the forceps were being organised), was then happy to watch them stitch me up, as I was so obviously NOT in distress.
I also had a "fear" of a cs - not per se - ie if it were genuniely necessary - but because I didn't want to be one of the statistics of those who had a cs "to cover the doctor's back". That might sound harsh - but is influenced by my dad, who is a doctor and who has always been outspoken in his concern about how medical decisions are now being influenced by fears of litigation - and his opinion that that has caused a high proportion of the increase in the number of caesarians.