Actually, did Superman have any fantasy sequences like this? Maybe something in "Last Son"? Cuz when he was the last of his species, he could arguably have even stronger issues with wanting to continue a legacy than Diana (even if he wasn't raised in Kryptonian culture).