Look in the medical literature and it seems outright spammed by reports on the positive effects of caffeine and negative reports on any of the harmful effects one would expect.
Similarly the main active ingredient of red wine (alcohol) is harmful, red wine in particular causes a lot of discomfort, dispepsia, hangovers and other unpleasant effects if you get a bad vintage but look the literature and it is like it will transport you to a blue zone and you will love forever.
And you find those kind of papers spammed in “real” journals, not MDPI or “Frontiers” journals.