I'll concede it's likely that most people drink coffee for the caffeine, but I would venture a guess that most people don't drink very good or well-brewed coffee. It doesn't really make sense to say that "coffee" in general smells or tastes bad because the range is enormous; it's similar to lumping all citrus fruits together.
I've had a hard time lately restricting my coffee intake to reasonable levels because I've had a lot of time to practice coffee brewing and some of the batches I've managed to brew have felt like drinking liquid chocolate. Even the same coffee beans will taste completely different depending on how you brew it.
I don't regret it at all though. Coffee is a luxury where a small investment goes a long way.