Had tickets in the south end zone for a number of years. Not bad at all. I would say you want to be in around row 30 or something. If you get right on the field, it would be awesome for td's in the end zone and all, but it would suck past the 30 yard line. In row 30 or so, it really only starts to suck at about the opposite 20 yard line.
I sat in the upper deck (about 10 rows from the top) for a game it just sucked. I remember thinking it sucked, even though I was wasted.