I live in an area with a large number of pubs that are local. There are ones as you described which are just full of drunks and shit quality overall which I avoid.

There’s definitely ones I avoid because they’re intended for families and the children will scream about the place as you would expect children to do. They’re great for families though, they have play areas for kids, those little claw grabby machines, they serve food and have a large beer garden with an outdoor play area.

My favourite one is a microbrewery, no kids, not too many people in there so bar staff can see who’s had a bit too much but the people who drink there generally don’t cause any trouble anyway.