To go from a brilliant satirist to becoming terminally online and just completely falling off the far right cliffs of insanity is incredibly sad. And unfortunately, this is plight is not uncommon. It is incredibly dangerous to make politics part of your identity and then just absolutely bathe yourself in a political media echo chamber.
I don't agree that this is a clear-cut example of a cautionary tale. I think for most people it can be a cautionary tale since it's common to chase things that promise hope in a desperate situation. We also shouldn't dismiss that someone can weigh the risks and take a gamble on something working out. I don't think there's anything inherently wrong or stupid for someone trying something conventional even if it backfires.
It's important to try and see this from Scott's perspective. According to him, he had his use of his vocal cords restored by a treatment that was highly experimental and during a time when all the official information said there was no treatment. If we are to believe his words, it worked out for him once, so it makes sense that he would decide to try things that are unconventional when his entire life was at stake.
In general this is not true, for example if you win the lottery the correct path is not normally to spend all of your money on more lottery tickets.
There are definitely other valid reasons to take unconventional paths though.