If the weather is a big deal to you, sitting in the top 3-4 rows on the home side, the overhang is very nice during the rain, and the views are still very good. As a bonus, there's no one behind you to complain when you're standing up the whole game (though it's also a detriment, since you can't force anyone to stand by standing yourself, and the folks up there don't get terribly into the game.)
My only personal requirement is to stay away from the end-zones as much as possible. But, like it was said before, there really aren't many bad seats, so a lot of it is personal taste. We're planning on moving up towards the front of the upper deck next season, but hopefully staying on the home side, since I don't like wearing sun glasses.