The question of “how sick is sick?” isn’t something which can be simply answered by some sort of Vatican decree; the principle of subsidiarity means that it’s best left to those at the coalface. Certainly there are some priests who will happily anoint anyone who moves and a few who don’t, and some Catholics who think that the sacrament is for anyone who feels a bit run down. At the same time, I’m not a doctor and I can’t exactly ask attendees at a mass for the sick to produce a doctor’s note justifying their need for the sacrament. All I can do is explain the criteria and leave it up to individual consciences.
Similarly, having previously been chaplain to a major hospital, I would say that, in general, if someone is sick enough to be in a hospital then they’re sick enough to be anointed. In fairness, there are some exceptions to that (day surgery for example) but I take the view that something like cardiology sounds pretty darn serious to me and so the person should probably be anointed. Likewise, when it comes to the elderly, while the canonical test refers to danger of death due to advanced age, it doesn’t specify a threshold obviously because this will be different throughout the world (we are, after all, a universal Church). There are some people I know in their late 80’s or even 90’s who are reasonably spritely and active, at the same time it only takes a single fall to dramatically change that (as an aside, I note that the author of that article himself died at 74). I would say that anyone who has reached the point of needing full time care should be anointed. Sure, they may well continue living for years - but that misses the point.
Allowance also needs to be made for particular circumstances. As an example, prior to going into lockdown, I anointed as many of our elderly parishioners as I could given the well known vulnerabilities to Covid-19 on the part of older people. I also anointed a parishioner who was a nurse aged in her late 40’s simply because she was going to be undertaking testing of suspected cases, putting her in a highly dangerous position. Another situation where circumstances need to be taken into account is patients in secure mental health facilities. Although not physically ill, there is a significantly heightened risk of self harm in such cases.
Ultimately, I’d agree that the pendulum has swung too far the other way - we’ve gone from people only requesting/receiving the sacrament when they were on the verge of death, to people only mildly unwell lining up to be anointed because of some vague perceived spiritual benefit. Still, proper reception of the sacrament needs to be encouraged. Sadly, it doesn’t get nearly as much airtime as it should possibly because it tends to only be administered at daytime anointing masses, and in institutions. I’d agree that better catechesis is needed but also wider appreciation of what is a beautiful sacrament.