Dunna fret, I had 2 fantastic and positive labors and deliveries, I would honestly do them both again in a heartbeat.
DS1 - hypnobirth. I didn't need pain relief, he was an optimal birth in the most optimal position. I had a small episiotomy and recovered brilliantly.
DS2 - epidural birth. I had to be closely monitored (he wasn't well in utero) and went into labor at 9pm. Decided on epidural at 10.45pm as contractions were coming very close together but with slow dilation (I was only 4cm) and I wanted to rest so had my epidural placed at 11pm. Was woken up to push at 6am, DS2 arrived in 3 pushes.
The reason why both deliveries were such a joy to me, is because I felt listened to all the way through. Whatever I wanted or needed, I got.
That being said, I didn't have my baby in the UK so you may have to wait for pain relief depending on your trust, but going into it with a positive mind and one that is open to changes is good.
Don't be scared to ask for what you need and don't be intimidated by anyone telling you you "don't" need something. You know yourself, keep your power and don't try and be a hero. There is nothing to be gained from refusing pain relief under the misapprehension of it being "better".
Childbirth hurts, of course it does. But there is a massive difference between "pain" and "suffering" - with DS1, I told myself that as soon as I tipped from "pain" into "suffering" I would request the epidural. It just so happened that it never did, but with DS2, became very painful at the very early stages.
Every labor is different, even for the same person (me as a case in point!) - but going in with a positive frame of mind and excitement rather than terror and fear will go a long way with how you see it after the fact.
And each time someone tells you a horror story, ask them what, in fact, they hope to gain from sharing that kind of negativity? It serves no purpose to scare the shit out of pregnant women under the pretense of "letting them know what they're in for.." - it's cruel, and the reason why so many women are terrified.