Prince Andrew was always his mother's favourite child, but did that contribute to his downfall?

It is an accepted axiom that every child should be a wanted child (which can discomfort those of us who weren't in that category at the outset). But is it always an advantage to be an 'over-wanted' child? Perhaps the now discredited Prince Andrew falls into that classification.