What is giving birth like?

I just found out I'm pregnant and I'm ecstatic but I'm incredibly nervous about birth. Was it worth it? How bad was it? What was your recovery like? Anything you'd be willing to share would be great. I want to be prepared.