There are two kinds of coffee in my brain:
Third wave fancy coffee I make at home in our Chemex or Technivorm or get in really really good shops, as you describe.
McDonald's, gas station, donut shop coffee. It's swill but you confectionize it with cream and sugar. Double double as we say up here. It's not good, but it it's a utility. You just don't expect much from it, and that's fine
The problem coffee is the stuff in-between. Stuff that pretends to be specialty coffee, overroasted, overpriced ... but not actually good. Starbucks or restaurant espresso. Grocery store whole bean coffees that markets itself in a nice bag but turns out to be stale oily overroasted mediocrity. Simultaneously expensive, raises your expectations... and then just turns out to be junk.