I had an elective C-section 19 months ago as DD was breach and I am happy to say it was a really positive birth experience. Sure, there is pain associated with it (I guess like any birth outcome!) but I got some great advice from a friend that has had 2 C-sections (one emergency, one elective).
Get up as soon as the medical staff say its ok to, use the pressure socks they offer and make sure you do lots of little walks around the ward (as much as you can comfortably manage). I used to push DD in the hospital bassinet around the ward, she'd settle with the motion and have a sleep which was a welcome bonus too. The nurses used to joke I'd wear out the carpet! Holding your tummy and scar very gently when you laugh, go to the bathroom, etc, helps as well. And using the bed handles, rolling on your side and using your arms to get up rather than trying to sit straight up from the bed really helps too. The nurses are usually pretty helpful with other tips and yes, they do offer you painkillers quite regularly- although I was feeling ok by Day 3, taking them just helped manage those niggles.
By end of Day 3 I was ready to go home but stayed in hospital the extra days for the breastfeeding help and rest. By the next week I was vaccuming and by week 4 I really felt back to "normal".
Everyone is different and recovers at differing speeds but I think for at least the first 6 weeks, all Mums, no matter how they delivered, need to be kind to their bodies. I'm about the have baby#2 (also C-section: so clever of me to have two big babies that are breach!), so it will be interesting to see how I heal this time. Its funny, even though its not that long since the last birth and I know there was pain associated with it, that's irrelevant when I look at my little girl- she's such a joy and just so adorable (even when she's telling me no all the time) that I'd go through a thousand more levels of pain to have her.
Good luck to all Mums-to-be!