By "heavy censorship" I generally refer to prohibiting pornographic content, foul language in the comment section, and removal of content their moderation team deems offensive.
Two recent controversies show Nexus's guts. The first one is deleting the pronoun removal mod for Starfield, which is basically the Nexus team's way of dictating their personal biases to the mass public and putting them over the message the mod maker wanted to deliver. No matter if the message was right or wrong, the point is that Nexus interfered with the community and enforced their own decision. The second one is claiming ownership over people's work by prohibiting mod creators from deleting their mods. It is self-explanatory, a way to secure their library, and a clear statement "your content is more important than you".
It is genuinely disappointing to see Nexus getting this level of support. In today's society a cool one-click mod installer is enough to cover up monopolistic, corporate-driven practices, I guess.