Well I am not sure about the sex scenes one.
But when it comes to Rough Beasts what exactly was he expecting? Any time a major character goes in a controversial direction you can always expect plenty of fan backlash and as an author you got to prepared for that. This is especially true when you operate in a shared universe and our not the sole creator. Not that I think personal attacks are okay but I honestly don't see it as a surprise that the changes he made to Sisko split the fanbase.