For any location where I was using it for more than a week I’ve encountered something unpleasant. Various degrees and extremes, but in my experience (not OP) it certainly seems to be intrinsic to public transit.
Some of these could arguably be a net good (it’s much better that the drunk is on the bus rather than driving himself!) and I continue to prefer transit over driving myself when available, but I would never deny that it’s not always an enjoyable experience
When I think about these things, I interrogate my frame of reference. At least for the US, the most appropriate contrast is the road trips I've taken, during which I saw no shortage of drunk drivers and general mishegaas at gas stations and rest stops.
The issue is that my city promotes itself as a good example of public transit and receives accolades from public transit folks, and naive people take it as archetypal.
I haven't owned a car for three years and public transit has been fine most of the time, but I live in a city that prioritises public transit. On the rare occasion that I can't get a bus somewhere there is a car sharing service I can fall back on.