Theres not a bad seat in the house. Just get there!
Upper stands have a good view but are a little removed from the atmosphere IMO. Dont really sit there much and even though Ive had season passes for the stands I always end up at the bottom. Went a whole season without even seeing my Upper West seat let alone sitting in it. Yelling at offcials and players is frowned upon. Good though if you want to watch the game with 18 odd thousand people in peace. Upper West is the 'sit and clap' brigade. If it's going to rain then both stands are a must or you'll be needing a $5 tarp and umbrella.
Lower stands are a great option with the best of both worlds. Lower East has a great atmosphere and has more of the banner waving diehards. Closest seats you'll get to the action and if your next to an exit will be the easiest seats to use the facilities. Lower West, especially the seats at the front by halfway are great for seeing the players close up as the bench sit right there.
North Stand are the cheap seats where you sit on the grass bank. As
Raurimu Massive said, standing at the North end fence will at times have you witness a try so close its like the players have jumped out of your TV and scored on the coffee table. You'll have to guard your spot though as theres always someone behind you waiting to take it.
South Stand are the cheap seats that have seats! Best place in the house to drink your smuggled in alcohol and yell abuse at players and officials. Most of the crowd will join in. Still get to watch a good game but as with both North and South stands, you can be at the wrong end depending on which half it is and who's doing all the scoring. I usually follow the Warriors and sit in both stands. Tickets arent an issue there as you dont have to produce them for either stands.
When I take people from overseas to their first game I almost always get seats right at the front of the West Stand in bays 15-12. That would be the best place to soak in most the atmosphere. For a good view go to the Upper stands. Cheap day out, either North or South. As with all stadiums, food and piss will cost you your weekly grocery bill and half your mortgage payment so make sure you bring cash. Long queues for the cash withdrawal stand and they charge a fee though EFTPOS is availible at most food stands. Like I said, theres not really a bad seat in the house. You'll enjoy it no matter where you end up sitting. Hope this helps...
North Stand fence. From the fence to the dead ball line is no more then 5 metres.
View from the South Stand.
Get pretty close to the action from the lower stands of both East and West. This photo I took from the East Stand.
View from Upper stands.