2006 Colts: Lost 3 of last 5 games, had worst rush defense (back when running the ball mattered some)-Won Super Bowl
2007 Patriots: Steam rolled opponents- Lost Super Bowl
2009 Saints: Lose last 3 games-Win Super Bowl
2010 Patriots: Roll off 8 game winning streak, most in dominant fashion and against 5 playoff teams. -Lose divisional Round
2010 Packers: 8-6 at one point, one loss from missing playoffs -Win Super Bowl
2011 Packers: One loss, and pretty much steamrolled through opponents. -Loses Super Bowl
2011 Giants: 4 Game losing streak, horrid pass defense, one loss from missing playoffs-Wins Super Bowl
2005 Colts, and 2006 Chargers are two other teams who steamrolled through the regular season only to be one and done.
2008 Cardinals are an example of a team with an unimpressive regular season record who made the Super Bowl. (Remember that Pats game). Cardinals were also pretty uncompetitive in some of their other losses.
A win is a win, once you get into the playoffs what you did in the regular season does not matter.
The only thing I really look at in the reg season (other than wins) is the QB play. Because, in this era, your Super Bowl aspirations are capped by your QBs potential. Brady has not played great thus far, but we know he's capable of playing great. There was a five game stretch in 2010 (Pitt, Ind, Det, NYJ, CHI) that Brady was just ultra efficient. He's capable of putting on that type of streak in the playoffs, and if he does, the Pats have a good shot.
Best team in the league doesn't always win the Super Bowl. There is just too much parity in the league for that to happen. A good offense can have a bad game, a bad offense can have a good game. Same goes for defense.
So while a lot of us can say this does not look like a Super Bowl team, remember this: There have been teams who have not looked like Super Bowl contenders during the reg season who have won it all. You don't need to look like a Super Bowl team during the regularson season, you just need to play like one for 3 or 4 games in Jan/Feb