It really depends on your baby, and how you parent. My husband took a week off with DD, and to be honest it was nice, because we got to travel to my parents for them to see the little one (4 hour drive), and it was nice as I did have a csection.
But to be honest, when it came to the baby, there really wasn't much for him to do. I breastfeed on demand, and don't believe in bottle feeding (for us). She would only sleep when I was around, as she needed to be nursed to sleep. The only thing he REALLY could do was bath, or change her diaper.
Since I used cloth diapers, it took him awhile to adjust to them, and for the most part I have changed all her diapers.
As for the bathing part, while... she got one bath in that time and it was 4 days after she was born.. So again, not really much he got too do, since all she really did was eat sleep and poop.
Having said that, we had pre-made meals, and our laundry and everything was already in order. So our house was keep in order, so not much needed to be done either. So for him, it was nice having him home, but he was useless in the sense of the baby...
Honestly, he used this week of too fix little things around the house, and get our garage in order (we just built a house, his dad was here, so he took advantage of that opportunity during that time).
Again, he's taking a week off, but again I really don't foresee him being helpful lol. He didn't really become helpful till she was 6 months, and wasn't soley on breastmilk.
Each family, each child, each parenting choice is going to be different. Play it by ear.