I'm not a Detroit fan, but from an outsider perspective I think Yzerman's done a decent job.
Ken Holland didn't leave much behind in terms of prospects, and the bigger ones like Zadina haven't developed. That's forced the "Yzerplan" to turn to free agency, adding tons of veteran players the last two off-seasons: Compher, Copp, Gostisbehere, Perron, etc.
Other than a couple of swings-and-misses (Chiarot), the problem as I see it is the Red Wings forward group. Other than Dylan Larkin, the club is filled with those "middle-6" type of forwards, and definitely need another top line talent. If Yzerman were to add a DeBrincat-type talent, I think the consensus on his work my change.