Definitely true for us. When considering kid #2, wife claimed that she actually enjoyed being pregnant. During pregnancy for progeny #2, she was like "WTF was I thinking?" To be fair though, pregnancy 1 was super easy for her and #2 was far more difficult in terms of sickness and breathing and what not.
There was no way she was considering a C-section though. She did enough rotations in OB to know that's definitely not what she wanted if it could be avoided, especially when considering having a whole gaggle of kids. Probably not a big deal if only having 1 or even 2, though even 1 freaks me out a little bit.