There's no way to tell what it's going to be like for YOU. Everyone is so so different.
I had a really easy pregnancy - only one sick incident, and stayed very active right up until DD was born 16 days late. A bit of carpal tunnel like you. I was out shopping at 40+13 and salespeople were like 'you should be at HOME resting!!'
Pregnancy ended in a c-section... DD was induced and 3 days later, nothing was happening. (3 days sounds horrid but I was pain free and quite comfortable). When the decision to have a section was made, I cried a little, because I had heard so many horrible stories about the pain and recovery time etc.
As soon as the epidural wore off afterwards, I was able to stand up, and I was in no pain at all. The midwives kept bringing around painkillers and I kept telling them I didn't need them. They convinced me to keep them up, but I was often late taking them and never felt anything. I saved most of them and keep them in my medicine cabinet at home in case of migraines :)
So I was walking around freely from day 1 (taking precautions of course), taking nice walks to Tesco on day 3 to do some shopping, and was sightseeing all over London with my niece who came to visit from abroad when DD was 1 week old.
DD was a reasonable sleeper, and apart from 2 horrid days in the antenatal unit, I didn't feel especially sleep deprived. Just toddled along... mind you I was absolutely rubbish at getting out the door on time for anything for a good 8 months but... I did make it out. A lot.
I went through a rough patch between months 4-7. DD started sleeping through at 3 months, but then regressed and by 6 months she was waking every hour or so. It was horrific. But it soon passed and it was such a small period of time in the grand scheme of life.
So all of this is just to reassure you that not every birth / post birth is terrible, motherhood isn't always the hardest job ever, and you might be lucky and have it easy.
But I guess if you are prepared for the worst, as I was, then at least if things go wrong you are ready, and if they go right then you can look back and wonder what all the fuss was about.