John Gregory was popular during his stint as Aston Villa boss - but his departure wasn't what he had hoped for