Probably will get downvoted for this, but a bunch of my family members are pharmacists. Their quiet opinion is that most pharmaceuticals don’t work. Even the ones that are thought effective. The data is anecdotal, but is over 15 years of watching people come in for prescriptions. The other aspect, is they say it’s mind boggling to see what kind of drugs people are on.
Of course you are going to get downvoted and you should. I know my blood pressure medicine works for instance because every time I talk to my doctor about reducing it or getting off it, I monitor my blood pressure and it spikes. I know psuedophredrine works. And your data is just that, “anecdotal”, it’s no better than the people doing “research” by watching YouTube on the toilet.
It’s best to look at all cause mortality in your example. Many studies have looked at that endpoint if you are curious.