The restrictions aren't in the game though, it's a combination of paywalls and self-censorship of indy creators who want to monetize their work, the game itself is sandboxy enough to make pretty much anything you desire. The restrictions in place on the hub are understandable, given the roasting MeshedVR got by the media and from a legal standpoint, he needs to take into account, as best he can, the restrictions on pornographic material where he's seeking to sell his game. the last thing Meshed needs is people putting PestSFM level snuff all over his site and it getting banned banned by ISP's and yeeted of Patreon. Because that will kill the game.
In my view, the best hope you have for extreme content is creating it yourself, and/or F95Zone fostering a community that creates and shares content that falls outside what is permissible by the Hub, but complying to this sites rules, which are far more lax. There is a wealth of knowledge here and this site has already spawned a couple of talented creators.
As for Reddit, since the opening of the Vam Hub, the maintenance of the Reddit threads has went completely to shit and great content by inactive creators has been lost. However, many of the people on this site were using Vam prior to the Hub, so, if you find a thread with dead links on Reddit, ask here. There is a good chance that if you link the thread, someone will have downloaded it in the past and can reup it here.
