Personally I see Detroit finishing at about 11-5. About them winning a Superbowl within this next decade, yes I actually would be able to see that. To the credit of other posters, yes Caldwell certainly is a great coach, his one bad season in Indy aside (he gets a pass for that since he couldn't really control the various things that happened to them that year), he's been one of the best coordinators and coached them well in the opportunity he did get, and Dungy really reared this guy up well.
I think one reason though why myself and a few others are still not drinking Detroit's coolaid is that I and I think a few others aren't quite buying Stafford as an elite QB yet. I watch the guy and I still see tendencies coming out of him that I think are gonna end up costing that team in some big games, aka next two weeks in Zona and NE, and possibly the playoffs as well. I see a better Lions team than before, but I don't know about one that's gonna go over the top just yet.
Obviously too they've got a few outdoor games in some crazy cold left that just may go against them. For example, even if the Bears are bad, if that Dec 21 game of theirs in Chicago ends up with those infamous -20 degree temp with 50 mph winds blowing, that could end up neutralizing their team.
The way their upcoming schedule shapes up here's how I see it
at Arizona (L)
at New England (L)
Chicago (W)
Tampa Bay (W)
Minnesota (W)
at Chicago (W if weather is normal, L if weather is bad)
at Green Bay (L)
I still don't think they're ready yet to win playoff games.