The Tigers, Pistons, and Lions you reference may be thoroughly inept at executing whatever plan they have, but their plan most definitely includes trying to win a championship.
I am always amazed at the level of telepathic prowess people assign to themselves when it comes to determining the motivations of others.
Alone among all of those teams, the Wings have actually won championships in the modern era, yet you seem to somehow believe those other clubs' motivations are driven by on-field success while Detroit's is not.
It's a pretty impressive, and wholly flawed, starting point.
I mean, your whole gripe about the Wings is how they aren't tanking to get better picks. Are the Lions? Are the Pistons? The Tigers? Yes, the draft is a tool of varying usefulness between those leagues, but literally none of those franchises are following anything close to the roadmap in their respective sports. They're all doing what the Wings are doing, except doing it worse, and you don't recognize it.
The current approach of the Detroit Red Wings completely prevents any realistic chance at ever winning another Stanley Cup again,
At least you aren't overreacting.