I'm with monkey, I had a nice birth! Just gas and air, only 4 hours once I got to the midwife unit, and it really wasn't as bad as I thought it would be.
I think the thing about birth stories is that you tend to only hear/notice the scary ones, people like me who have lovely births tend to keep quiet for fear of sounding like smug bitches.
I think mine was a mixture of luck, a relatively small baby, coming on his due date rather than two weeks later, and having done lots of yoga and belly dancing throughout - the former gave me great positions to use and the latter strong core muscles. But luck was the biggest factor!
So first timers, don't worry. It can be lovely, but there's only so much you can do. Just prepare as well as you can but keep an open mind and don't stress it too much, if you have a rubbish time that's what the drugs are for. It clearly hasn't put off a lot of the second-timers on this thread!