While not technically SFF (though certainly a pulp adventure fantasy in a lot of ways), the Amelia Peabody mysteries by Elizabeth Peters has self-reflections on her maternal capabilities and relationships with her children (biological and adoptive) as a central feature of Amelia’s character. I don’t know whether that would be to taste because of the borderline nature of the genre, but I find it mostly entertaining, in part because Amelia often refers to her own lack of maternal instincts.