No none of this is 'good'. Petraeus became a WH insider the instant he bedded a married women. That is to say he compromised himself and destroyed his independent credibility.
IF he actually did bed a married woman.