I love giving birth. Big time. I've had all my babies now, and the thing that makes me consider more (fleetingly) is being able to give birth again.
It's the most incredible, bizarre experience, and sometimes I'm sad for DH that he won't get to experience it. The pushing stage is amazing. Like you're just sitting in your body and it suddenly starts doing everything without you. It's a reflex to give birth - who knew! Once you give over to it, it's pretty amazing.
Yes, it is painful, but the pain is different to normal pain. Psychologically, it's not a warning, like burning your hand or cutting your knee, so I find it quite manageable.
The only time I didn't was when I had an unexpectedly fast first labour and was told I had 12hours at least left before baby arrived. I panicked thinking I would die of pain before then, and the second I panicked, I was suddenly in unmanageable pain. DH brought me back down, and DD1 was born 20 minutes later!
I've had 3 completely unmedicated vaginal deliveries because I never needed the pain relief, despite being in pain (I know that sounds bizarre). 2 fairly standard births (though back to back) and one breech twin birth. I was fortunate in that I only ever had a graze (with my second), but nothing else. Though I do attribute that in part to being able to move freely etc due to lack of pain relief.
I just wanted to share this to demonstrate that not everyone thinks of labour and childbirth as this horrible traumatic pain they had to endure. And I know other women who view it positively, too.
The trick is to stay calm. Easier said than done, but breathing is really important, and the better you breathe, the easier it is. As PPs have suggested, htpnobirthing may be good for you