Before marriage, I made sure my partner agreed with me that if we had kids, we would not act as if our kids owed us anything. I did not want to bring people into this world just so they can work for me.
If they want to, and we happen to live near, then great. If their goals take them elsewhere, then that is great also.
I don’t think parenting is a bad deal for the same reason any other kind of entertainment or fulfilling lifestyle choice is a “bad deal”