I came onto this site looking for answers too, seems we all have the same issues. Our first is not a good sleeper and never has been. People say its a phase and it will improve, well, it got to 6mths and it didn't! He's now 8mths and will wake about 4-5 times a night and he's just started waking at 4am and being WIDE AWAKE and not wanting to sleep.
My wife is taking the brunt of the night time work as I have to work in the day, she's on Maternity leave. She is just so exhausted, she feels sick through exhaustion and is now actually getting sick, as her defenses are down. The little man is attending Nursery 2 days a week now and he comes back with new germs each time, he's got an awful chesty cough so he feels terrible I'm sure. Whatever he brings back, I then seem to contract, so I am permanently poorly.
So, to the OP above, you are not useless, nor helpless, you are a new parent and I think we are all going through similar issues, but every baby is different. My brother had a daughter who has slept through every night from birth. They don't know how lucky they are!
People say if you have a terrible sleeper, your next child is a good one. My worry is , what if this IS our good one!