I dunno what instance you're on, but I have allowed NSFW on lemmy.world and rarely have I seen porn. Thankfully a lot of it is over at lemmynsfw.com instead so I can see stuff labeled NSFW here without being flooded with porn. Unless .world defederated from lemmysnfw at some point. I haven't paid attention to much meta news and who has defederated from who.
I hope the Fallout and Final Fantasy wikies also migrate out from fandom. Back when they were wikia, they were a lot better. It feels that the search function on fandom is so bad that half the time you're better off going on google and slapping your search there instead.