I had two elective caesareans (not in the UK) they were both positive experiences. The most unpleasant was having the spinal but after initial discomfort of needle I was instantly numb. There is a weird tugging sensation, but you are honestly so distracted by the excitement of meeting your baby it is barely noticeable. They brought the baby over to me immediately for a while and then across the room for apgar test etc. DH was with baby then.
Within minutes baby was back with me and in my arms. With my first child DH and nurse took baby down to nursery while they sewed me up and then they brought him to me in my room for a feed.
With my second, she stayed in my arms while they sewed me up and wheeled us together back to my room for first feed.
When the spinal wore off I was very sore, but the pain relief they gave after was amazing and worked instantly. I really battled with wind which was so painful (apparently happens with all abdominal surgery)
I was up in 24 hours (getting up for the first time hurts, and I was very wobbly on my feet but is a turning point in recovery and is the moment you start to feel you are getting stronger)
I stayed 3 nights, going home was fine (stay ahead of pain with the medication they give you)
The only thing I couldn't do for a while was lift my toddler, and I really battled bathing baby (as the angle and height of my scar was tricky) my DH bathed both babies for the first few weeks, which I missed out on and felt a bit cheated, but in hindsight it was very empowering for him and he really bonded with them.
I would choose elective caesarean again in a heart beat, it's no walk in the park, but was a very calm, organised and special experience for me, I remember every little detail because I wasn't overcome with pain. My kids love hearing the stories of their births (they are teens now!)
Good luck with your decision.