Dan Ashworth was acclaimed for his work at Brighton but his tenure at Manchester United was short-lived and costly