I agree that "horny wife" is better than hypnosis, but I'd still prefer the alcohol trope. Though the "aphrodisiac" trope is, in my opinion, exactly the same trope as hypnosis. And if the alcohol trope is used similarly to the aphrodisiac trope than it's just as bad. But my big problem with "horny wife" is if it's a corruption story the corruption has already taken place. I want the corruptible character to start more pure, not necessarily the "prude" trope where they don't know a single thing about sex, but not fantasizing about anal all day either. I want them to have taboos they feel uncomfortable violating to give them room to be corrupted. That's the point of the game in my eyes. So the horny wife trope might be slightly better than hypnosis but they both basically kill the game for me if you lean into them too hard.
Hypnosis is hard to use in moderation. The only way I've seen that done is "she was only willing to go so far in the first hypnosis session and then next time she goes farther, etc". Horny wife can be moderated by just having her have a totally normal sex drive, but I've seen very few examples of it used this way. It's almost always "I am so turned on and willing to upturn my whole life because his cock is bigger and that's secretly all I think about". Alcohol seems to be the easiest to work into a story without totally derailing it, though to your point I frequently see it used carelessly also. The best case of alcohol is the heroine is beginning to falter internally but won't let herself make a mistake sober, and then she drinks and goes JUST A LITTLE too far while drunk. Then she has to deal with the consequences later and it just sets up a believable circumstance for her to have taken that obviously inappropriate step. Blackmail can be used similarly. That's my two cents anyway. So far I've really liked Mr Palmer's writing, especially compared to his contemporaries, so I feel like he'll do ok with whatever trope he tries to use.