Lambeau is a great old stadium located in a really quaint neighborhood. You don't even have to pay to park when you go to a game there. You just drive around in the surrounding neighborhood and park wherever you find an open spot along the road. Then, at worst, you have a 15 minute walk to the stadium (through the nice, safe sidewalks of the neigborhood). Bring a seat-pad though, those metal bleachers get COLD.
Candlestick, on the other hand, is located on the scummy outskirts of South San Francisco. Because it is on a peninsula, there's a tight bottleneck getting in or out, and there's no free parking within a mile of the stadium. It takes hours to get out of the parking lot after a game. The stadium is a terrible place and a good portion of the fans are thugs. That said, Candlestick Point will be a decent place once they level the stadium (particularly if you like fishing -- there a couple good fishing piers right near the stadium).
---
If he's talking about Appleton, that's a pretty fun place to stay if you ever decide to go out to a Green Bay game. Lots of good bars and restaurants all in walking distance from the Radisson where the opposing teams stay. It's definitely no sh*thole.