Yes. Super Bowls are basically always played in a football teams' home town. However, no team has ever made it to the Super Bowl when it was being held in their hometown although it is possible for it to happen one day.
== == == ==
Pittsburgh Steelers running back Jerome Bettis played in his hometown of Detroit, Michigan in Super Bowl XL.
None. The closest a team has come to playing the Super Bowl at home was Super Bowl XIV when the Los Angeles Rams played the Pittsburgh Steelers at the Rose Bowl in Pasadena and Super Bowl XIX when the San Francisco 49ers played the Miami Dolphins at Stanford Stadium in the Bay Area.
Here's a link that will tell you all of the Super Bowl winners up to last year's Super Bowl, no new teams played the 2011 Super Bowl. It was played by Super Bowl veterans the Steelers and the Packers. The list at the bottom is up to date.
The teams have never played each other in a Super Bowl.
Rams and Titans
The 49ers and the Chargers.