I've had two, both brilliant.
The actual op is fine. They give you the spinal and then check you're numb before starting - I had no clue they'd actually started. When they're getting the baby out you feel some tugging, someone described the feelings during the op as being like they're doing the washing up in your tummy which is about right! You'll probably feel a bit lightheaded and nauseous at the start because your blood pressure will drop, but they'll give you something for it and you'll quickly feel better.
They'll hold the baby up for you to see, then bring them over to be checked. They take the placenta out with the baby, so on DC1, DH cut the cord. DC2 needed a bit of help so he didn't get to on her. They give the baby a quick check, weigh etc then bring them over to you. That's very quick provided all is well. You can hold the baby then, although i preferred not to while lying down so DH held them and sat by my head.
DH took the babies to recovery while they cleaned me up, moved me from the table back to the bed etc (just a couple of minutes). I then breastfed both in recovery, and ebf with no issues at all.
I never had much pain. Take the painkillers given to keep on top of it, don't wait to tell pain before taking them. If you're still in pain, they can give you something stronger so don't be shy about asking (I never needed it but some do). Get in lots of paracetamol and ibuprofen in advance - you go through a lot and with the restrictions on the amount you can buy it's a bit of a pain, so start picking up a couple of packs with each shop now.
Drink lots of water and eat things like dried fruit to prevent constipation.
Honestly, it's fine. I felt much more human once the catheter was out and felt a little bit better each day. Good luck!