A parade of scandals tarnished the prince’s reputation, long before he gave up using his title as Duke of York on Friday.