I've not read the rest of the replies - I'm far too tired atm! lol So I', just going to add my personal experience which will hopefully help you!
While I was pregnant with baby no1, I was terrified of labour right from day 1, like you I am a big baby and can not stand any kind of pain, I just do not cope with pain well at all! I decided that I would just have gas and air, I wanted an epidural sooo badly, but knew I would be too scared of how much a needle in my back would hurt!!! All the way through labour, I coped with gas and air, with a few shouts and grunts.. until finally it got so bad that I begged for an epidural - I didn't care how much the needle would hurt, it was too late though, and literally 30 minutes later (I think - it was all so hazy), I was holding my baby. I felt sick, and 'drugged' and totally 'out of it' but was glad I 'kinda' coped until half hour from the end.
Baby no2, after having been through it once... as soon as I found out i was pregnant, I cried.. I did NOT want to go through that again, even though I 'coped' better than I thought! Again, there ws the dilemma of wanting an epi - but being too scared of the pain of a needle in my back!! lol.. I did it - with gas and air. Again, afterwards I was tired, felt sick, and out of it, and didn't really know what was going on around me and everything was hazy!
Baby3, I'd planned again to do it with just gas and air.. but, by the time I got to the hospital he was starting to crown, I barely had time to get my pants off, so deffo no epi and no time to get the gas and air! You know what though? The faster the labour, the more intense the contractions are, it was agony.. I had no idea how to deal with that kinda pain.. but, afterwards while I was laying on the bed, cuddling my baby... I didn't feel sick, I didn't feel drugged, and I could remember my baby entering the world. I liked that.
Baby 4 and baby 5.. after realising last that with no gas and air, I could remember my baby being born, and not feel like I had drunk 18 pints of beer.. I wanted that again! I planned from the start to not have an epi, and not have gas and air. Luckily by this time I had found BnB, which is what led me to suh enjoyable labours! I bought a hypnobirthing CD from ebay, and used the internet to learn how our bodies deal with labour and pain etc. It was aonther very quick, very intense labour... I laboured at home, with no drugs at all, I breathed, I relaxed, and I dreamed of laying on a beach.. I let my body cope with everything on its own, and I also let my body do all the work. I didn't push at all, I didn't shout, I didn't scream.. and finally I delivered my baby myself. It was such an amazing experience that a day later, I wanted to go through it again!
Now, if I had another baby, I would again look forward to giving birth with no drugs.. I completely owe it all to the ladies on BnB. If I hadnt found this forum and read through mostly home and natural birthing threads, I would have had more gas and air with the rest of my labours, and again felt awful, and not remembered much of it! Educate yourself on all the amazing ways your body can cope with pain, and above all else.. not only tell yourself, but believe that YOU CAN DO IT! Because, you can!