C-section

Isit scary to do c-sec? Will there be any pain? Like will i be awake or sleeping hahah? So nervous because i always wanted to do normal birth. Would probably have to do c-sec just like doctor say instead of normal birth ☹️