Unraveling the mystery behind Bettye McCartt's character in The Offer and delving into her impactful role in the making of The Godfather