The Duke of Sussex has been celebrated as a "darling" of the Royal Family by the former press secretary to the late Queen Elizabeth II.