Where it went wrong for Steve Yzerman as Detroit Red Wings general manager

Yzerman's tenure in Detroit didn't take on the fairytale arc so many hoped for when he was hired. Where did it go wrong?