I have to admit that I find the whole Bear sex thing an amusing exploration of taking things to their logical end. I mean if you think on it if a Druid loses control while extremely aroused they very well could transform mid-coitus, it's kinda funny. It's not like the idea has never been explored, The Boys (TV show) showed what would happen if a superhero lost control (though that scene was decidedly less funny and more really gross).
Anyway, I don't mind sex, even somewhat graphic sex, in a game as long as it's not required to advance the story. Personally I think it was well done in the original Dragon Age and Mass Effect and it did add a level of interaction in a CRPG that felt cinematic and appropriate. It wasn't anything more graphic that one would find in an R rated film of the time. Where we are now is a bit of a stretch of what is appropriate, IMO, but this is an opt-in kind of scene, you are very unlikely to accidently get to this (and probably other) scenes. All I would recommend is to be careful of the Mods you choose...