I agree with you that with the right author, I can be tempted to try stories I wouldn't normally choose to read (except for death fics :/). I'm not a fan of BDSM, but have compulsively read that sort of thing now and then.
A good story-teller can overcome quite a few squicks.