Sweetie, I had a CS for my second birth. The first was a traumatic vaginal delivery with ventouse (I'd put in my notes that I absolutely refused to allow the doctors to use forceps).
It was because of the distress I'd suffered that my GP recommended a section and the hospital consultant didn't just agree, he was totally supportive of the suggestion.
I had my section on the Monday and was home on Thursday lunchtime. I came home prescribed with paracetamol, took 2 the first day home, 2 the second and needed nothing afterwards (and I am a WIMP! I promise you that I'm very sensitive to pain and squeamish too but honestly I was fine).
A week later I was hoovering my 3 bed house. My then husband was at work from 7am-7pm and totally, abusively unsupportive when when he was at home but I honestly didn't need him. Two weeks later I was almost back to normal, taking it carefully but doing almost everything I'd done before birth.
My section was calm and controlled. I felt in control. My then DH was there but I wouldn't have felt alone if he hadn't been. The theatre team were so kind, calm and reassuring I felt safe and supported.
The delivery of my second DC was wonderful, SO different, so much calmer and less scary and traumatic than the vaginal delivery of my first. I was awake under section. I had a spinal block. I knew everything that was going on, I was kept informed, my baby was handed to me as soon as she came out. I was given the option of going under because it was an elective section but chose to be awake because I'm a control freak! The anaesthatist came to see me the night before to introduce herself and answer any questions and when I went into theatre the doctors and theatre techs all introduced themselves by name and did their utmost to successfully reassure me and answer further questions.
You're NOT a failure for having a section. What's important is that you and your baby are safe, respected and well cared for, not how he or she came into the world. Please believe me, you're not "only half a mummy". Your son won't care that you had a section, only that he's here and that you love him. Trust me, my 2nd child is now nearly an adult and will tell you that!
Please may I suggest that you discuss an elective section under epidural or spinal block with your consultant and GP and find out what that would entail.
And midwives... they can be funny buggers. If you get a good one it's great but some can act above their station. The one I saw at the hospital after my GP had recommended a section told me she'd never heard of such a ridiculous thing and I'd never get it. She was so horrible that I nearly walked out with the intention of going back to my GP to request a termination. It was only my husband who saved my baby and I. He told me to ignore the "silly cow" and wait to see what the consultant said! He was right. The consultant was NOT impressed with her comments! So to quote my ex, don't listen to the monkey, ask the organ grinder.
My section was calm, controlled, safe, peaceful and the recovery a piece of cake in comparison to my vaginal birth. It really is worth considering.
Whatever you decide, good luck, don't be bullied, don't take first responses, get yourself well informed (as you are doing) and fight for what you want. If you feel browbeaten or that your rights are being ignored or overridden contact PALS and have them advocate for you.