Andrew did have good points, he served in the military and he served in the Falklands war, involved in actual combat. Andrew really took charge the day of the fire at Windsor Castle and afterwards.
We've all read how Andrew was his mother's favorite child and I think he was, perhaps, allowed more leeway than his siblings especially Charles, for obvious reasons. In addition, Andrew and Edward came along at a little later in the Queen's life.
Andrew really never grew out of his immaturity, self centeredness, extreme arrogance and a huge sense of entitledness. Unfortunately, he married a woman with the same traits. My first clue that the marriage was a mistake, was shortly after their marriage, the couple was at a State Banquet, I believe, and throwing eclairs or cream puffs at one another. It may have been at another formal dinner and not a Banquet. However, there's the tow of them acting crass and stupid at a formal occasion. I think Andrew thought that with his mother gone, he still would be taken care of and that his brother/family would make his problems go away, as always.