Definitely go. I've been following the Giants for over 30 years, long story. Oracle Park is rated as one of the best in MLB. The only problem is that they probably won't have much to play for by September. The season has fallen away badly after winning 107 games last season, the most in baseball.
I've never been to Oracle, I went to their old stadium at Candlestick Park but that was for an NFL game. I have been to Fenway Park which is full of character. Oracle is too, just several decades newer.