Always been on the fence, keep hoping I want to have kids some day, because I sure don't want to go into it with a negative attitude. I don't want to "miss out" and regret having lived a childless life when I'm 70, but I sure don't want anything about that lifestyle today. My wife seems to be much the same way. We always talk about "some day, if we have kids.." but nearing our 40s, some day doesn't seem to come.
I absolutely believe it must be rewarding in a way I cannot imagine -- just as most 'worthwhile' pursuits that take time and effort and learning and growth are. And precisely because the benefits are non-obvious (I don't really enjoy anything about being around children). I've found raising pets to be far more rewarding than I could have imagined, so I'm sure children must be 100 or 1000x that reward.
But, just like I don't need to take on every challenge the world has to offer (someone else can die on Everest, others can become passionate about their skydiving hobby), I'll pick and choose my challenges.