Beloved by musicians and with not enough fame of her own, this sleeper was known for penning hits for Streisand and others -- but her own performances are exquisite