I completely avoided any negative/traumatic birth stories, just didn't read any at all. I started a hypnobirthing course but to be honest I didn't do much, but this might be helpful, when you wake up in the night worrying to channel it into something positive.
I gave birth in October and it isn't fun, but despite having no pain relief at all it is bearable. I had an episiotomy and didn't feel it, I've heard the same with a tear, that you won't feel it at the time. I also had a ventouse delivery and didn't feel that at all. I barely felt being stitched up to be honest and still had no pain relief. I don't have some mega pain tolerance, I just tried to stay as calm as I possibly could. My recovery was absolutely fine and textbook. Just reassuring you that even if you tear, have an instrumental delivery etc, it doesn't necessarily mean it'll be awful. The staff are incredible, I delivered in theatre with a lot of people and honestly, they are amazing and do everything to soothe you and take care of you.
I really recommend a tens machine, an exercise ball and breathing - 4 in through your nose and 7 out through your mouth. Sounds simple but it got me to 6cms happily eating a mcdonalds and bouncing/breathing. I was the same as another poster, I dreaded it so much and built it up so much that I honestly expected more, I expected to not be able to cope but really, you do just cope!
It's also worth knowing that you'll have a moment of thinking/saying "i can't do this" during transition, that usually means you're ready to push. So if you have that moment, it's almost over and you can do it, you already have.
Good luck! You can and will do it x