I think all sports are great in person, even if you don't like sports. Despite not being a baseball fan, I usually get out to Fenway at least once a year and catch a game. You can get a 4 pack of tickets that includes 4 hotdogs and 4 beers for $100.
Only been to Gillette and watched the Pats once. A friend's family had season tickets at the time, and they decided not to go to the game last minute. Trying to do that again, tickets are like $300 each. Would be a $1,500 ordeal for a group of 4 of us to go.
Have seen the Providence Bruins a few times, but never Boston Bruins. Funny story though, in 2019 my boss bought Game 7 tickets day of, spent something like $8k. Only to watch them loose the Stanley Cup rofl.