Not Going To Lie, I'm Scared

W
Im 38 weeks today and while I'm so excited to meet my baby boy soon, I'm scared. I admit it, I'm scared. As a first time mom, all you hear is the horror stories. The hospital protocols, the procedures, the waiting, but most of all the pain. I support healthy moms and babies, medicated and unmedicated births, and the right to women's decisions. My goal is to have a non-medicated birth. I'm a realist, so I don't exactly go for sugar-coating the truth, but I don't necessarily want to go off of worst case scenario and negativity either. 
Ladies, especially if you have given birth without the use of medication, can you give me some insight here? Was it as bad as you thought it would be? Did you think you could handle it? What advice would you give?