Will this game be available on Steam Workshop
No, Steam really dislikes games that can have NSFW mods.
