Olestra (not a drug, but a chemical solution to part of the obesity problem) had a lot of promise. It didn't get banned, but people did freak out about a generally minor side effect, hold a health scare, and finally send it into commercial oblivion.