Long demonized by doctors and dieters alike, this sweet, mellow oil now appears to be a health food darling. Is it time to welcome it into your pantry?