The San Jose Giants are the Giants' low Single-A affiliate. The Giants' organizational ladder looks like this:
Sacramento River Cats (Triple-A)
Richmond (VA) Flying Squirrels (Double-A)
Eugene Emeralds (High-A)
San Jose Giants (Low-A)
ACL Giants Orange (Rookie League in Scottsdale)
ACL Giants Black (Rookie League in Scottsdale)
DSL Giants (Rookie League in the Dominican Republic)
Generally speaking the further you go down in the org chart the younger the players are, the less in the way of fan amenities you'll see, and the smaller the stadium will be (In the case of the rookie leagues they often don't play in stadiums and if they do there are no amenities for fans) There's a wrinkle in this particular chart though because the Emeralds share U. of Oregon's PK Park which, having been built for college ball, has been deemed unsuitable for minor league ball after 2025. The Emeralds'old park burned down; I believe they said it was arson.
You asked fugawe about Excite Ballpark, where the San Jose Giants play. This is technically still on the original topic because San Jose State also plays there. I have seen 4 games there now.
The ballpark was built in the 1940's as a public works project, so it has a pleasant, old-timey feel to it. Despite being old it's actually aging quite a bit better than the Oakland Colliseum. Lots of old memorabilia throughout, like images of major league alumni. It's across the street from a few SJSU athletic facilities and right next to an ice rink.
It has I believe about a third the seating capacity of Raley Field. Maybe a bit less. No grass seating. In fact there's no outfield seating at all, as it only extends about as far down the lines as each dugout.
As far as fan amenities they do have a fun "beer batter" promotion and some other contests. Also they have a new, big, and clear video scoreboard.
I liked how close the seats were to the action.
There are a couple of things I didn't like. One of them is that there's not that much selection when it comes to concessions, and I didn't think the hot dogs were that great. There is a big BBQ area down the third base line called Turkey Mike's. I've never eaten there because I'm rarely hungry enough at the ballgame to want an entree and sides. I'm given to understand they close the BBQ area for SJSU games
The other thing I didn't care for was the wide aisles between sections with a lack of handrails- and deep steps like you have at Dobbins.
The stadium has a peculiar design feature in the seating bowl. There are bleachers and box seats, without any real physical separation between the two seating types. In normal non-COVId-19 times you could be sitting in a box seat at the end of a row and the person sitting in the adjacent seat would be on the bleachers.
Still, a fun place to watch a game. It's worth going at least once.