D.D.
When I had my daughter I was completely under. I had back surgery when I was 12 yrs old and there was too much scar tissue to guarantee an epidural would work. My daughter had her head pushed into my ribcage and refused to turn. So a c-section was required. The doctor put me under and when I woke up I had a beautiful baby girl!. My husband was in the Operating room with me the whole time.
My daughter just turned yrs old this year. She is happy and extremely bright(actually doing 1st grade work in Kindergarten!).
Don't worry. Doctors always tell you the worst case scenario so that in the even something DOES go wrong they covered all the bases. If you are apprehensive about the procedure by all means seek a second opinion.