I was terrified for my spinal with my now toddler. I was shaking and crying hysterically and they said I need to be still and I was fully sobbing that I wasn't going to be able to keep still and I was going to be paralysed. They then told me it was done!
To be honest my caesarean went a bit south, they said I'd feel mild tugging but it felt more like they were slamming me up and down! Baby had been breech since day dot and boy was he lodged in my ribs! He came out and I didn't hear anything, just silence and he wasn't laid on me for skin to skin, I spent a few minutes not really knowing what was going, dh cheerily telling me that the baby had a big poo and was covered so they couldn't lie him on me (total lie!) I don't say this to scare you, quote the opposite actually, a few things did go wrong but it was absolutely fine. I didn't feel in pain, out of control, sick, anything, and even when I was anxious and confused I was still ok, and most importantly once baby had the help he needed he was awake, and aware and could hold him. I'm sad about how parts of the experience went but the spinal, the surgery and the staff was absolutely fine. When they had to be a bit rough to get the baby out, it was communicated, they chatted throughout, dh held my hand, he described the baby to me. I do not regret being awake even through the scary bits! I was nauseous after, but you're nauseous after general too! I was worse after a ga a few years ago for a non child related surgery.
Good luck, whatever you choose. It's your birth, and it's your choice. I just wouldn't want you to miss out due to fear so thought I'd share.