TBH I think the problem with Clippy was more a problem with its implementation than the core idea.
It just wasn't helpful and we lacked the tech at the time to really make it helpful. My impression was that it was basically a glorified AIM Chatbot with some hooks into Office to get some context.