Nowhere? it's right where it was

I am unable to find it in the Workshop myself.

When I do an internet search it appears, but when I open the link it comes up with the error "You must be logged in to view this item", but I found a link to the mod page's changelog which I can in fact look at:

https://steamhost.cn/steamcommunity_com/sharedfiles/filedetails/changelog/3393172805

EDIT: Accessing the main page from that link made me verify due to the 'Sexual Content' descriptor, so it may be hidden in the Workshop for you depending on whatever your preference settings are.

The main page link is:

https://steamhost.cn/steamcommunity_com/sharedfiles/filedetails/?id=3393172805

Thx, but I have all the special content in preference setting allowed. So I don't know whats
going on here.

I could simply search for it just fine, but yes that's the culprit usually.

Some mods that are deemed as mature content are hidden in the search unless you're logged in with preferences set specifically to allow them.

This is not "special content" though.. the settings for it are in your Store preferences (so the dropdown list in the top right near your avatar, then store preferences) where you can see several categories of what type of content is permitted to appear for you. The "community" checkboxes are what apply to mods. I have all 10 boxes there checked, which is probably why I had no issue searching for the mod.

I know what and where the shop preferences are. I have only 6 there, 3 for the shop and 3 for the community and all are allowed. I call this 'special content', in Germany it is called 'content not suitable for minors' or 'adult content' and I am btw over 60^^.
So I really don't know what is going on here, because this Mod isn't shown even using the workshop search. Btw I worked in computer business.....

At least for me, there are 5 categories in the preferences section:

https://steamhost.cn/steamcommunity_com/sharedfiles/filedetails/?id=3501680118

Three of them pertain to nudity / sexual content, varying in degrees. Legend of Shem is marked with both 'Some' and 'Frequent'. The modder may have added those descriptors due to nude statues or something like that.

If you only have 3 categories altogether, I wonder if it's some region-specific configuration, and the existing sexual content filter does not include those marked with the latter 2.

Yes, it does seem like it if you don't have all the options :)
Two possibilities I can think of:
- one being what Dread said above that it's region specific
- the other one is that you actually have your birthday set on steam and it's set to a date that would make you not old enough to have those options.

The 3 Options are all "Filter for adult content", All are allowed, so again not understanding why this happens. The other 2 for shop resp. community I don 't have.

If you look at the screenshot provided by Dead above, you'll see that the options are actually escalating in nature.
Also if you're viewing your store page in German, then it's very easy to mistranslate them as they all roughly mean the same thing aka. "mature content", basically all 5 of them, it's just small nuances separating them.
My guess is that you simply have the first 3 options available due to some form of restriction and the mod would be classified under the 4th one as "Frequent nudity or sexual content" and as such is hidden for you.
Either way, the mod is still where it was, it hasn't been moved or changed in any way and this is entirely a steam store thing excluding it from the search for you.

N, the 3 options visible are:

Allgemeine nicht jugendfreie Inhalte 
General content not suitable for young people (or minors)

Häufige Darstellung von Gewalt, Blut oder Verstümmelung
Frequent depiction of violence, blood or mutilation

Gelegentliche Darstellungen von Nacktheit oder sexuellen Handlungen
Occasional depictions of nudity or sexual acts

and all are allowed, what others options you have I don't know.

But we can stop discussing this topic now. I think it can't really be solved because I deleted cookies and set my correct age and nothing changed.

Yes, that's what I was trying to tell you :)

You only have the first 3 options available and not the last 2... but you NEED the last 2 (more specifically the 4th, Frequent nudity to see the mod - which don't even show up as options for you.

This means that your account for whatever reason is restricted to under 18 content only. It could be that you initially set your birthday incorrectly or so (platforms like these won't change restrictions if you later change your birthdate, they simply "won't believe you"), or there could simply be some law in your region forcing them to only allow certain content etc.

But the bottom line is that for one reason or another, your account is restricted so it's an account thing and it's not something with the mod or steam etc.