I was a big fan of both David Bowie and Queen when I was a teenager. When rumors came out that David and Freddie were both gay, me and my friends were all conflicted. We had zero tolerance for homosexuality. But I loved their music and kept buying their albums, regardless of what my friends thought. I didn't care if the rumors were true, the music spoke for itself.
It depends on what the company is using its money for. Goya makes fine beans, but after seeing them lined up on the Resolute desk, I won't buy them. There are other beans. The owner of Boston Beer Co. is a trump contributor, so I won't buy Sam Adams products. There are other beers. Local car magnate Ernie Boch Junior is another vocal trumper; I won't ever set foot in one of his dealerships. There are other car dealers. The My Pillow guy is just a caricature and his product is a joke. The Hobby Lobby is out and The Salvation Army will never get a quarter from me (I outgrew my homophobia). All of these organizations use their profits for causes I vigorously oppose so I won't give them my money.
If a company's leaders are shitheels but that company is just using its money to thrive and enrich its shareholders, as companies do, then I don't care about that. They only pique my ire when they use their profits for evil.