A drug that genuinely has no effect is actually pretty good; most drugs have some sort of risk and many are seriously dangerous. Rofecoxib is believed to have caused around 100,000 heart attacks and 30,000 deaths. Market approval for rofecoxib was based on misleading data and its withdrawal from the market was substantially delayed by misleading data.

https://en.wikipedia.org/wiki/Rofecoxib