He abused women, that is different than getting sex. It is rape. He used his power to abuse, not to get sex. There is a significant difference.
And he also used power to cover his abuses. But the women didn't wanted sex with him, didn't find him attractive. So no aphrodisiac. If is was an aphrodisiac, he won't have been denounced. The women would have braged about being with him the same way they brag about being with Leonardo DiCaprio or any hot male star. Weinstein wasn't attractive. That is the point.
Brad Pitt, George Cluney, DiCaprio, take your pick. All of them get hot women that find them attractive and say so. With Weinstein? They were disgusted. I'm surprised how you can talk yourself into believing that any of the abused and raped women might have find him anything but repulsive. And power didn't changed that. Just give him the tools to abuse unchallenged and get away with it.