This gave me some insight. I've always wondered why people support charities that do things in the western world (ie research cures for cancer) when dollar for dollar you are better off feeding and educating children in developing countries if your goal is to prevent human suffering. At first I thought it was racism, then maybe nationalism, but neither explanation ever fit every case. Maybe these people can't handle the suffering of a mother in Africa making less than a dollar a day to feed her 8 children so they don't think about it at all in the first place.
While related, I think you're overestimating the capacity of the average human being to make such calculations.
Since they are incapable of determining the maximum effect of their dollar (at least, not without intense effort), they simply make the choice that feels the best, and that will usually be determined by the proximity of the suffering.
Secondly, many people invest in cancer research because everyone might get cancer. They aren't hoping to reduce suffering generally. They are thinking "I or my friends might get cancer and collectively this research might save my (or my friends) life."
Nobody cares about the suffering of people they've ever met. I mean, intellectually we all do, but emotionally, no, you have to see the person (or at least talk/text with them) to care.
As depressing as it is, your "average" human being is not making any decisions based on a rational estimation of the best way to achieve their goals. If they have goals at all. They pretty much just try to muddle through.