I've had two elective caesareans and one emergency, and I have never had a problem.
They are very nice to you and you don't see anything scary or gruesome, although your birth partner may. You should be able to hold the baby almost straight away.
Nowadays I think they give you a spinal anaesthetic which is a one-off (not an epidural which is what I used to think it was) and can last for hours or wear off very quickly. You will have a catheter, which sounds awful but is in fact fabulous that after the last few months of having to get out of bed every hour for a wee you can just sit in bed all cosy.
I'd advise that you take every bit of pain relief going. They don't bring the drugs trolley round very often and if you don't think you need anything just yet you may find that you do need pain relief quite urgently in an hour's time but there is no one to get it for you. So take it when offered, and keep "on top of the pain."
Many hospitals have little cots that clip on the side of your bed, which are very handy when you have had a c-section and can't get out of bed. But you may have to ask for one. They also often have a sort of ladder thing on the bed that helps you to sit up. If you don't get given one, ask if they are available.
This might sound stupid but when I had my first DC I didn't ring the bell when I needed anything because I had been in hospital before and thought it was only for emergencies. It probably is in other parts of the hospital but in the maternity ward, after a c-section, you are allowed to ring it. (It still made me feel like Lady Muck though.)
I'd suggest taking some trousers that fit when you were 4 or 5 months pregnant to wear. The more the scar is supported the less it hurts, in my experience. I found very loose trousers uncomfortable. I always find it lifts my spirits to get dressed, if I hang around in pyjamas all day I feel as if I am ill.
More a general recommendation than a specific c-section one - don't bother with paper knickers, buy cheap Bridget Jones ones from Primark or Asda and throw them away.
Take food in with you. They don't feed you enough and you will be very hungry.
Get up and moving as quickly as you can.
Um . . . will come back if I think of anything else!
Good luck and congratulations!