I was terrified of having a vaginal birth, but the reason for that was my history of numerous "down there" problems. You don't mention why you are afraid, so I can't comment on that, and it's a perfectly valid emotion. I spoke about it with a lot of people, most of whom were not particularly nice or helpful.
Fortunately, the only important people - my OB and my husband - were very supportive. I would encourage you to speak with your doctor about your concerns. We discussed all the options, my medical history and the issues I was worried about specifically, and at the time my OB felt like I had a good chance of a problem-free vaginal delivery. However, given my issues, he was also willing to do what would have been essentially an elective CS. I thought about it a lot and decided I'd go with his recommendation. In the end it didn't matter because I failed to progress, so I would have had a CS regardless of what I wanted or was afraid of.
While I can only speak for myself, I had a very easy recovery and only one day (immediately following surgery) when I was truly uncomfortable and in a decent amount of pain. In the interest of full disclosure, I have to tell you that I did have a lot of support and didn't have to do much by myself but I would have been able to manage just fine after two weeks. By that point, I forgot all about my incision because my cracked nips hurt a lot more. Obviously not everyone had this sort of experience and there are lots of horror stories, but then again, there are lots of horror stories and complications with vaginal births too.