I'm generally on your end of the spectrum with regards to children and I always hoped to have some.

But, I've met plenty of people who absolutely detests their parents and visa versa, their parents detest them and they are mean and rotten to each other. So YMMV as far as the entire topic goes.