I've been to two games here in San Francisco (and one in Oakland) and both at Candlestick were not too great. The stadium is pretty bad by todays standards. The first game was OK until Derrick Holmes fumbled on the 1 yard line and it was returned for a touchdown. We lost that one, but it was close. The second one was a Sunday night game few years back and we got killed, I was so drunk, I missed the bus and had to cab back to the city and the Northstar and it cost tons of cash.
Seattle was just great all around. It was a lot of fun to stomp the Seahawks in their own stadium. The fans were very quiet in the second half. My only complaint was that there was no tailgating because it was right in the city, and they needed more bars in the vicinty of the stdium. Beer lines inside moved fast, though. San Diego always is very very slow.
The women in Seattle are very friendly too. Had a wild night before gameday. It made for a very debacherous time. I think New Orleans has the potential to top it.