In the early to mid-nineties, I was shot into the heart of the industry (on the east coast). I helped build espresso bars, train baristas, and sell coffee for two of the industry's premier roasters. I worked with one west coast and one east coast roaster.
I learned a lot about "good" coffee.
One thing I learned is that most people are pretty ignorant about coffee. I learned that most coffee shops sell crap and pass it off as "good" coffee and their loyal clientele supports them no matter what. I'm not talking about Dunkin's here... I'm talking about the little coffee shops with cool names, funky furniture, a hip staff and small roasting machines displayed in their windows. Roasting coffee correctly is very difficult. Most non-industrial equipment can't do it right. Most of these smaller roasters over-roast the heck out of the beans and ruin them before they are even ground. Then they tell you it's just strong coffee. There are exceptions of course.
As Ashdigger pointed out, you can have the best beans and greatest roast in the world... but you can kill in during the preparation.
There are so many factors that go into making coffee or espresso that "perfection" is a rare thing.
WIth that said, it's still possible to enjoy coffee.
I love coffee. I have had what some would consider incredibly good coffee. I have almost every apparatus you can imagine to make/prepare coffee.
I love a Kenya AA with a medium/Vienna roast done right. Some Ethiopian Varietals and Latin American Varietals are terrific. When I can, I get some beans from Gimmee Coffee which is based in Brooklyn I believe. It's great stuff.
I am also highly satisfied with a nice robusta grocery store blend. All the better in a percolator which kills the character of any coffee and makes the most homogenous, blandly flavored coffee. There's not a lot of complexity in Maxwell House anyway.
The only coffee I tend to turn down is Keurig-type coffees and that industrial coffee that comes as a liquid that you dilute and drink. They don't taste like coffee to me.