I've been to 6 concerts this year. You don't have to be part of the insane rail crowd. I've done a mix: one stadium, one arena, 2 midsize places, 2 downright small places. I don't do GA when it's in the big places, I take a seat. But, everywhere else, I've never smelled a floor shit. People aren't ridiculous at my shows, but maybe that's just the crowd being different. I usually have no interest in the current mainstream headliners, so maybe that's why I'm missing out. But, at each, I get to be the boring crossed arm guy swaying on the back rail. I usually slide up for a song or two for the view before sinking back.
But still, they can be expensive. I have a limit. I've caught a couple deals buying resale the same day as the show. I get it if that's the ultimate deciding factor. But if you enjoy the music and the artist performs well live, I'd recommend at least trying a show before assuming everyone shits on the floor.