I've been to a decent number of concerts since my tinnitus got bad, with no problems, always using at least foam plugs.
The thing is, with seated shows -- you have a lot less control. Shows are usually mixed to be 95-102db at the soundboard, so seats right at the soundboard would probably be too loud for me, if they went on more than a couple hours. This also means if you happen to be right in front of a speaker stack you'll get more noise (though in reasonable, well-mixed venues, the odds of volume peaks anywhere exceeding 110 are not that great, and you're definitely not dealing with sustained volumes in that range).
So, I like unseated shows because I can move around and find a spot where the volume & visibility are decent. You won't be able to do that at a seated show, but it could still be fine; if it were me, I'd probably go, use a meter to figure out average and peak volumes at my seat, and then bail if it was more "too loud" than "awesome, fun!"
The average concert is 110-120 dB
Some shows can certainly be that loud, though 120 (even as peak spl) has to be on the rare side, and is going to be in violation of applicable regulations more or less everywhere.
My experiences at mid-sized venues around here (~600 person capacity) is that volume towards the back tends to be 80s average with peaks into the 90s, totally fine for me with plugs. Moving up to the center of the venue where the sound board is, the average tends to be more like low 90s with peaks into the high 90s, and the loudest I was able to get the meter to register by holding it right towards a speaker was about 104.
Whether "close to the front" is bad or not really depends on how the speaker setup is. Sometimes there's a wall of stacks in the air mid-way back, such that people who are 2/3rds of the way back get dosed a lot harder than people right up front. So, I hate seated shows because of the uncertainty, plus the uncertainty about whether the person in front of me is going to decide to smoke DMT constantly and keep falling backwards into us (yes, this is a real thing that happened, at a Shpongle show at Red Rocks, Colorado...)
Here was the setup for a Kurt Vile show we went to a couple months ago. From here we had a pretty good view, great bar access, and volumes under 90.
Kurt Vile & Courtney Bartnett said:
When I was young, I liked to hear music blarin'
And I wasn't carin', to neuter my jams with earplugs
But these days I inhabitate a high-pitched ring over things
So these days, I plug 'em up