I have no delusions that teams in general care more about fans or winning or anything else than profits. But there's a big difference between:
1) Profit
2) Profit
3) Profit
4) Winning
5) Safety
6) Growth of youth interest in the sport
7) Charity / community / good will
And:
1) Profit
2) Profit
3) Profit
4) Profit
5) Profit
6) Profit
7) Profit.
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. And none of their general managers would say that if you expect championships, you're in the wrong league...or that less success can be more exciting...or any such arrogant drivel that assumes the fans that have just witnessed two decades of unprecedented success, have suddenly transformed into blithering idiots, with no frame of reference, and no backbone to want you held accountable for your choices and actions.
The current approach of the Detroit Red Wings completely prevents any realistic chance at ever winning another Stanley Cup again, because it's not possible to have mediocre draft stock, and preferentially draft wingers, and ignore significant trades altogether, and overpay depth players...and still concentrate enough successful moves in a short enough window to have the horses to win it all.
It's the difference between the Lions drafting a variety of player positions, and just choosing poorly...versus drafting almost exclusively running backs and tight ends, and telling the fans to hang in there, because teams move up and down the standings all the time. One method is frustrating and disappointing, while the other is a rather embarrassing strain of insanity.
But at this point it's likely a matter of waiting out (or walking away from) however many more wasted years that it takes before fan apathy forces a change. And what a great chapter in the history of this storied franchise this shall turn out to be.