OK, again I was wrong, to label their "success" sporadic. But on the other hand, the thread is championship appearances. So I should have said that their championship appearances in MLB are sporadic, for whatever reasons.
Since moving to the AL Central in 1998, they went to the World Series in 2006 and 2012, losing both times. The latter was Detroit market's last championship appearance. https://en.wikipedia.org/wiki/List_of_Detroit_Tigers_seasons
I mean really, if you shift back 30ish years from 2012 you could say a similar thing for the Twins, except we won both of ours and since joining the Central we've had a couple handfulls of playoff appearances.
I don't think(?) either the Pistons or Twolves are close. Vikings and Lions may seem like either close or in the right direction .... yet so, so far away ....
So for both markets, I would think NHL is the best chance for the next appearance, though I have no idea if the Red Wings are in a good position to break out of their six year slump of not even making the playoffs.