Not that scary, honest! You will change into hospital gown and have the cannula in. You walk into the operating theatre and hop onto the bed rather than be wheeled in, which I found odd! They ask you to sit on the bed and flump over a pillow for the spinal block. I had one needle to numb the area, and then the block. It is odd feeling the sensation start to melt away! They will check you can't feel anything and reassure you. They put the catheter in and you don't feel it. There will be a lot of people in the theatre, and they'll all probably introduce themselves to you. Anything you're not sure about, ask the anaethnatist who will be nearby monitoring you - they will be able to explain all the odd sounds of the monitoring machines.
The surgery itself is fine, you feel tugging and rummaging, but nothing painful. It takes about 10 mins to get the baby out, then another 50 mins to stitch you back up. I kept asking for time checks! If all is well with baby you or your partner can hold once they're checked over. I felt really shaky with the anaesthetic so didn't at the time, but DP sat by me holding her.
Recovery was fine, I was up and about with the catheter out 12 hours later (remember having really bad trapped wind and apparently it's normal), discharged the next evening, had to hold my stomach when coughing or laughing for a week, was able to walk about round the park after two weeks, and got clearance from my doctor to drive after three. Scar healed pretty quickly too and has just left a thin line at the top of my bikini region.
I'm having another DC early next year and will be having another caesarean, so they're not that bad! Writing this all out was good to jog my memory actually.
The worst bit for me - and I thought about not saying this, but I think it's worth mentioning - before the operation they read you the long list of things that can go wrong so you can give informed consent. I lost the plot and sobbed when they mentioned the very, very minor possibility of death. However I'll be going into it this time around reminding myself that it's a routine procedure and giving birth is risky too.
Good luck, let us know how it goes!