I had a section for my twins - one head down, one breech. I won't ramble about my experience because I don't have time, but to answer your specific questions ....
How soon could you lift your baby?
I don't remember not being able to lift them. I could lift them from the plastic bassinet in the hospital while lying on the hospital bed immobile and with a catheter in, I just had to adjust the bed to get above them and pull the bassinet right alongside. I struggled a but to put them back, but buzzed a midwife to help. The midwives will help you if you need them to.
How long before you were up and about in the house?
I stayed in hospital for 2 nights. Showered the morning after my morning section. I thought the midwife was mad when she told me to go for a shower (didn't think I'd be able to walk!), but managed and felt so much better. Pottered about the ward on day two. Just took it easy for a few days at home - no hoovering, but could walk up and down stairs carefully.
How painful was it and do the drugs work?
They're effective! The local in your spine is not pleasant. But then you didn't expect it to be, right?! I held my DH's hand and thought of the babies I'd soon be holding and the tears fell, then it was all done and I laid down for the delivery. No pain at all during delivery, though you can feel movement. Kind of like when you lie on your arm funny and wake up with a numb hand - you can still use your hand but it feels somehow remote. With a spinal, you can't move at all, but you still have some sensation. Afterwards, you can have paracetamol, ibuprofen and codeine. They work pretty well, though I did feel like I'd been hit by a truck for the first 24 hours. You still function though, and the euphoria of having babies negates a lot of the hit-by-a-truck feelings!
and do they affect how alert you are with your newborn?
I don't think so, but I've nit had a natural delivery, so can't compare. I was awake and alert through the operation and until I dozed on and off through the night. I spent the majority of the first night propped up in bed (still couldn't move legs!), with pillows either side of my raised knees, babies on lap, staring at my beautiful babies
. The best night of my life. Once you're home on paracetamol, ibuprofen and codeine, you'll be knackered, but it's nothing to do with the drugs (I don't think).
I had a pretty straightforward planned section. I lost a lot of blood and was on iron pills for a while, but other than that, recovery was quicker than I imagined. I wasn't bed-bound when I got home, I only stayed in 2 nights, I could walk and lift my babies once the spinal wore off (12 hours or so to completely wear off), and I was driving after 2 weeks (ring your insurance co - mine said I could drive when I thought I was sufficiently recovered to drive safely. Some people suggest once you can jump up and down you are sufficiently strong to do an emergency stop without hesitating).
Good luck whatever you decide 