I had no idea what to expect before I gave birth with it being my first. I tried reading and preparing myself as much as possible but quickly discovered that there’s no blueprint for childbirth and it’s clearly not as portrayed in TV/film!!
As you can see from previous posters there are just endless different scenarios. Mine, however, was as follows:
Latent phase began on a Wednesday morning before my midwife appointment at 39+6 but only had a few contractions and they didn’t restart until Thursday morning. Had contractions sporadically throughout the day with hours rest sometimes between them until 11pm when they got a lot stronger lasting about 30seconds and 10/15 mins apart. I first phoned hospital at around 4am as they were starting to get much more painful but was advised by midwife to stay at home as long as possible. From this point on I couldn’t sleep because of the painful contractions. The pain was similar to period pain but more intense which increased to a peak and then faded.
Mucus plug started to dislodge in the afternoon and managed to stay at home until 4.30pm on the Friday - during the few hours previously the contractions had become unbearable and something in my brain instinctively said I needed to go in.
After arriving an hour later I was 5cm and encouraged to go into the pool (despite not being keen on a water birth). This made it easier to move about but don’t think it gave me much pain relief.
At this point (and for the rest of established labour) the contractions were coming with virtually no break in between. Was given gas and air but I struggled to concentrate on it when having contractions and didn’t really get any pain relief from it. I ended up being a screamer (I really struggled breathing and acting calmly so this form of release worked best for me) clinging on the bath handles and biting on a towel. After about three hours I had enough of the water and wanted to get out and ended up on bed on my back (the only position comfortable). Waters broke just before pushing stage started (another thing I didn’t realise varied so much in childbirth)
Pushing stage stung as you would expect but nowhere near as bad as the contractions for me. The only frustrating thing about it was that baby would go back in slightly after each push. Once head was out though rest of body quickly followed and the sense of relief was amazing.
Honestly, the moments after baby was delivered felt great - both me and partner were in tears and I felt overwhelmingly relieved and euphoric which made the hours of labour before quickly fade away.
Unfortunately I can’t reassure you that childbirth isn’t painful - because it was the most painful thing I’ve experienced. However, I didn’t use much pain relief so may be worth looking into those options and discussing with midwife.
Overall, it was a great experience where I bonded with my partner, baby and also the lovely midwives who took care of me. Care was one to one. After baby arrived and first feed had been done they offered to look after baby for a bit so we could sleep. However, I was so high on adrenaline I couldn’t sleep so spent the early hours of the morning talking to my midwife about all sort of stuff (they were quiet so had the time). A bit strange really when you consider that hours before she had seen every part of my body! 
Discharged the following morning as there were no complications.
Good luck with your pregancy and best wishes for baby’s arrival. Get as much advice from friends, family and midwife as you can. Have a good browse on Mumsnet too as I spent ages looking at loads of threads. After reading all the NHS material and other professional information it was refreshing to read real-life examples of childbirth - especially the more recent stories (its crazy how quickly you forget the pain and reality of childbirth once it’s over).