There was a really good cappuccino in a local coffee shop that was, in fact, my introduction to liking coffee.  Hadn't drank it much in college or in my early working career.  Later, working a lot with the Brasilians both in Sao Paulo and up in Bahia state, I got used to much better coffee.  They made it spectacularly good there.  

The most overrated coffee in the world?  Three that I can remember:

1) Turkish coffee - like drinking sludge

2) Arabic coffee - an aftertaste that I don't like

3) Danish coffee - they are really proud of it.  For the life of me, I cannot understand why.