Sheba - I had a c section for a breech baby and was very scared. It actually was fine! Not as bad as i expected. I was shaking so badly but the staff were so great. At the time it was uncomfortable mainly because of big belly and position i had to be in - but i have no clear recollection of the actual process. It was over quite quickly and then i dont think i thought about again until long after the birth - so no long lasting trauma! The staff said it is easier for a planned c-section, rather than when you are in active labour as they dont have to time the needle in between contractions. /i also asked the staff not to show me the needle or anything as i would have lost it if i had seen it!
All in all, my c section was a really positive experience.