Most retirees want to leave something for their children, but while such devotion is understandable it may be misplaced.