I came here for the first time with my husband on June 17 for the Giants vs the Padres (San Diego won that game by the way). We took the train (Caltrain) from Belmont so we could save on parking and not having to deal with the traffic on our way to San Fran. The train stop from the stadium is a pretty short walk, so I would highly recommend taking it, especially if you want to save on parking.
Anyways, I loved the view from my seat (yep, I was higher up, in the nose bleed section) because no where have I seen from any stadium that you can see the bay. The scenery is truly stunning and so unique to San Francisco.
The food sold at the stadium is going to be overly priced here, so if that is not what you are willing to pay, then make sure you either eat dinner before coming or buy up some snacks at the Safeway that is pretty close to the stadium (yes, you can bring in your own snacks and nonalcoholic beverages... I even saw a guy bring in a whole rotisserie chicken!). The food itself here has plenty of options to choose from, not just your standard fare of hot dogs and hamburgers (although they do have that too if you are old fashion). But I didn't find a salad though (yes, I know you are not coming here for a salad, but I am a fan of adding fiber to all of my meals).
I wished the aisles between seats weren't so narrow because walking through it can be scary. I totally dislike it when people either do not stand up or move their legs in so that someone can pass by to get to their seat (it's really hard not to use the restroom during the entire duration of the game now). I only got up once and both times I walked through the incredibly narrow aisle, I thought I was going to fall forward into the seats below me. (But of course, all stadiums out there have narrow aisles since the goal is to put as many seats as possible, but still, wished it wasn't so narrow).
I love that the weather isn't too hot where we were sitting, nor do I think it would be hot sitting in the stadium because the weather is usually on the colder and breezy side in San Francisco (make sure you bring a jacket or pull over to keep you warm at night).
Overall, had a wonderful experience at this ballpark and would love to see another game here.