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.
I accidentally got in a condition that can be compared to the ones describing autism. I remember how it is to be emotional but I choose not to go back (even if theoretically it is in my power). Autism has its drawbacks but it also has its perks. There may be others like me who actually just choose not to care (emotionally) or not to become a(n emotionally) caring person.
Indeed, I am still able to make rational decisions, but it would be a lot easier if I didn't feel their pain wouldn't it?
See, being on the other end of the spectrum isn't a choice. I will feel everyone else's emotions, whether I want to or not. I might even think they're completely insane, or immature, but I still can't help but feel empathy. Doing so can be extremely exhausting.
Autistic people don't choose to not care, and I didn't particular choose to care (or more accurately, feel), it's just the way I am.