The reasons you stated above were very much the reason I preferred DC's Earth-2 Universe over their more mainstream one, and I'm saying this as a 25 year old who only started reading superhero comics a few years ago. In that universe, the heroes (including Batman, Superman, and Wonder Woman) were allowed to age in real time, get married, have kids of their own, and move on to OTHER things in their lives rather than stick to superheroics for all eternity. When their kids grew up, it was actually pretty interesting to read about how they handled being the children of legacy heroes. And yes, on Earth-2, the kids of superheroes were actually allowed to LIVE and didn't get blown up or murdered as plot devices to drive the superhero parents. Thank god DC decided to bring that universe back.
Re: So I'm assuming you are talking about superhero comics, and in that case: