I wasn't paid for all 6 weeks. My wife and I had to save up a cash cushion (and her leave was paid because her company had wayyy better benefits than mine). It was a decision and an expense that was important for us, so we saved up for it because we knew that my wife would probably be out of commission for the first six weeks our boys were born and the first 4-6 months of twins is a crapton of work.
I never felt guilty when I came back to work. Once you really internalize that people in a company are replaceable, you just start preparing people for when you leave on vacation or baby leave instead of worrying about it.