Hmmmm Water sports/ golden showers can turn me on in a story if it's written really well also some other stuff none of which would normally even turn me on in my fantasies....

It really depends how well written it is and what the context and theme are.