Hi Ladyem, please don't worry - it sounds like you've been on the receiving end of childbirth atrocity tales. I had an emergency CS when I had dd and, though it's not what I'd have chosen, it was really fine.
First, the drugs made me a little shaky, but only a little, and I didn't throw up (or even feel sick).
Second, administering the spinal was completely painless - really, no problem.
Third, it's true that dd didn't feed till we were in recovery. When she was born they showed her to me, then checked her over, then gave her to me for skin to skin contact while they stitched me up. I fed her in recovery shortly after, and she took to it beautifully.
I would say that the actual CS was no big deal - and mine was an emergency, at the end of a gruelling labour, so not ideal conditions. Tbh, I think the recovery after is more of a big deal, but not so much that it should put you off a clinically necessary CS.
Also, talk to your midwife about options for the CS. My obstetrician has started doing CS that is as gentle and natural as possible - they did a photo-essay in the Guardian on it about three years ago. Basically, they have low lights, take the baby out slowly and gently, and give it straight to the mother for skin-to-skin contact and breathing. It looked a really lovely way to humanise the procedure. It is only suitable for elective CS, but why not see if your obstetrician could introduce some of this? (My obstetrician was Philip Steer at the Chelsea & Westminster, by the way.)
Seriously, there are good reasons for trying to reduce the CS rate, but a clinically necessary CS is a good thing and shouldn't be a bad experience for you.