You're right, there are a small handful of unusual cancers that we have cures for, and that's great. And some small progress has been made overall. But a lot of money has been spent, and it has been half a century or more, and we don't have much to show for our efforts.
You are right that progress is slow and expensive in a lot of areas.
It seems you are frustrated or angry about it. What do you want people to do? Are we not spending enough on research? Are we spending too much?
This is mind-bogglingly wrong for most cancers. Several death sentences have been turned into treatable diseases.
Yes, it would be better if we had more complete treatments but it’s far from nothing. I have a friend who was given 6 months to live a couple decades ago, right before a treatment for his not especially rare cancer was approved. He didn’t expect to see his daughter leave elementary school but is still around for her post college career – and as a scientist himself is keenly aware of how much hard work made that possible. We can simultaneously acknowledge that progress has been made but cancer is one of the hardest problems humanity has tackled.
In general though, I tend to agree that in the US we spend far too much on what essentially boils down to performative end of Life Care. If you ask someone if they would rather spend $200k for 2 months or leave it to their family, I think most people would pick the second option. When someone else is paying, they choose the first option.