Kind of amusing (not) when the non-fans/Sox fans chime in to try to intimidate or make a visitor feel like he'll not have a good experience. Assuming decent weather, the op will have a great time.
I'm sorry I have been out of town and didn't notice this thread earlier. I could potentially have offered some advice on where to sit and other options for getting tickets. As a season ticket holder myself, I'll be happy to answer any questions the op may have about the ballpark or the neighborhood. Feel free to PM me.