IMO...best pre-game atmosphere is The Detroiter (bar and grill). It's located a half a block outside of Greektown (very, very easy to find and get to from Greektown). It's on Beaubien St. They have shuttle on 10-12 minute loop starting a few hours before and after game (although the after game the loop is more like 20 minutes due to traffic). Shuttle ride to game is usually a raucous ride, with Let's Go Red Wing chants and everyone very cool and into the game. Food there is nothing fancy. But it's quick, and pretty good.
Many other places above are good as well as mentioned above. Have fun and welcome to Detroit. Go Wings!!