The biggest example for this IMO is Vitamin D. If you can spend time in the Sun regularly every day, you won't ever need to touch vitamin D. But how realistic is that for most people ?
The only supplement I've encountered so far that has a noticeable effect that cannot be reproduced with any realistic diet is creatine.