I've had 2 emergency sections (although one under GA because they couldn't get the epidural in in time).
I've had lots of cannulas in my arm over the years.
I can PROMISE you that a cannula being inserted usually feels like a scratch, then a tiny bit uncomfortable but that is all. I am totally needle-phobic (and a wimp to boot)and never look at what they are doing and it is not a big deal.
I have only had a spinal/epidural in emergency situations and can imagine that with a planned section this bit might be a bit strange or daunting. Just get your partner or the anaesthetist to talk to you lots while it is going on- it will take your mind off it all and should help. It won't hurt- you get a local anaesthetic first and thereafter will feel pushing.
Recovery is the bit of sections that I hate, but even so I marvel at the fact that 2 weeks after such a big operation I can be up and about and almost normal. I suffered in the first couple of days after mine (especially the second time when the hospital people told me I should be ok with just paracetomol and ibuprofen!) but the good thing about a planned section is that they should be able to take the time to get your pain meds right and also that you won't be tired from labour which should aid your recovery.
My tips are:
Definitely get up as soon as you can but take it very easy- I overdid it and got shipped back to hospital.
Don't be a martyr. Take whatever pain meds are offered and don't be afraid to ask for more if you need them.
Giant pants that come up to your natural waist are key.
Take in an extra pillow - the NHS will probably only provide 1 and it can be good to put one over your scar when you hold/feed the baby.
If you want one, ask the medical people if someone can take a photo of the baby being born, weighed or whatever. I really wish also that I had a photo of my DH in scrubs, he looked lush even though I was so knackered from labour I could hardly see!
When your scar has scabbed over you can massage it daily (gently!) to help break down any bumpy scar tissue and improve the appearance of your scar.
How exciting - you'll meet your lovely baby ssoon!